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
What are the operating systems in which sybase could take its presence?
State some of the criticism about sybase iq?
Explain update statistics.
Explain coalesce. What is the equivalent of oracle/db2 coalesce function in sybase?
What you need to do is issue an ase kill command on the connection then un-suspend the db?
How to find the time taken for rollback of the processed?
What is trace flags — 5101 and 5102 in sybase?
What is the difference between db-lib and ct-lib in sybase?
How to start and stop sybase database in linux sap?
How do you view log files in sybase?
What is sybase replication server?
What will you do if a replication thread goes down?
What sybase central?
How do I bcp null dates in sybase?
List the types of locking?