what is the difference between dbcc checkstorage and other
dbcc commands
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
How to connect to sybase database from linux?
What is difference between sybase and oracle?
How do I set a password to be null?
How do I configure identities in sybase?
What is the relationship between jdbc and sybase?
What is table partitioning in sybase?
Can I use a named pipe to bcp/dump data out or in in sybase?
What are the operating systems in which sybase could take its presence?
Using large raw partitions with replication server on unix in sybase?
How do I connect to sybase?
How would you check the long running transaction?
How do I create a partitioned table that spans multiple devices in sybase?
What will cause the size of a stored procedure to grow in sybase?
How would you replicate col = col + 1 in sybase?
Is sybase a database? Explain.