Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between dbcc checkstorage and other
dbcc commands
- 2 Answers
- 11885 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
What is the difference between natural join and equi join?
How do the blocker processes exist internally in sybase?
Does sybase support row level locking?
What are the best monitoring tools for the sybase database?
How do I open sybase control center?
explain engines?
How do I set ts role in order to run certain dbccs?
What is a good example of a transaction in sybase?
State some of the products of sybase?
What is trace flag definitions in sybase?
How do I find the oldest open transaction in sybase?
What is sybase used for?
Differentiate between replication server and sql remote?
Explain about the sybase group?
How to check if sybase database is up and running?
