Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between dbcc checkstorage and other
dbcc commands
- 2 Answers
- 11734 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
When you change a database option when will it come into effect?
How can I improve throughput in sybase?
List different types of sybase index.
How do I bcp null dates in sybase?
Explain locking?
What mandatory options are required for bcp command utility?
Which should I use, repagent or ltm in sybase?
List the types of locking?
Explain coalesce.
What is the depth of triggers?
What does –i option do in sybase tools?
What will cause the size of a stored procedure to grow in sybase?
What is rollback trigger in a trigger?
How do I configure the burn factor in sybase?
What are the catches?
