Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between dbcc checkstorage and other
dbcc commands
- 2 Answers
- 12007 Views
- I also Faced
- E-Mail Answers
Answer Posted / jayakumar
1.dbcc checkstorage runs checks against the database on
disk. If a corruption is only in memory, dbcc checkstorage
may not detect the corruption. To ensure consistency
between two dbcc checkstorage runs, run checkpoint before
running dbcc checkstorage. However, doing so can turn a
transient memory corruption into corruption on disk.
2.dbcc checkstorage checks the entire database, including
unused pages, so execution time is relative to database
size. Therefore, when you use dbcc checkstorage, there is
not a large difference between checking a database that is
nearly empty and checking one that is nearly full, as there
is with the other dbcc commands.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
List the types of locking?
What is cmaxpktsz good for in sybase?
How to divide by zero and nulls in sybase?
What does –i option do in sybase tools?
How to connect sybase database from python?
Explain index covering?
Explain procedure cache?
How would you check the long running transaction?
Can I use a named pipe to bcp/dump data out or in in sybase?
How can you change to get the decimal separator as comma instead of the decimal point (.)?
Explain defncopy and it's usage?
Explain locking?
How do I move tempdb off of the master device?
Explain intimate shared memory(ism)
What you need to do is issue an ase kill command on the connection then un-suspend the db?
