Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between dbcc checkstorage and other
dbcc commands
- 2 Answers
- 11755 Views
- I also Faced
- E-Mail Answers
Answer Posted / sucheta khattri
dbcc checkstorage is different from the other dbcc commands
in that it requires:
1.)The dbccdb database to store configuration information
and the results of checks made on the target database.
2.)At least two workspaces to use during the check operation
3.)System and stored procedures to help you prepare your
system to use dbcc checkstorage and to generate reports on
the data stored in dbccdb.
4.)Unlike the other dbcc commands, the performance of dbcc
checkstorage does not depend heavily on data placement.
Therefore, performance is consistent for each session, even
if the data placement changes between sessions.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is the difference between natural join and equi join?
Explain autosys. Why do you need it.
How would you configure burn factor in sybase?
Using large raw partitions with replication server on unix in sybase?
Is sybase relational database?
What do you mean by deferred update in sybase?
How does sybase replication work?
What is a good example of a transaction in sybase?
What command helps you to know the process running on this port, but only su can run this command?
How would you list objects in sybase?
What data types does sybase support?
Explanation about replication server software?
How to take backup in sybase database in sap?
What is table partitioning in sybase?
Why do my page locks not get escalated to a table lock after 200 locks?
