what is the difference between dbcc checkstorage and other
dbcc commands
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 you need to do is issue an ase kill command on the connection then un-suspend the db?
What will you do if a replication thread goes down?
What is the difference between natural join and equi join?
what is the difference between an ltm and a repagent in sybase?
How do I tell which tables have identities in sybase?
How do I connect to a sybase database?
What is the drawbacks of normalization?
What are the catches?
Is sybase open source?
How would you lock a table in sybase? What text command will you use for it?
Explain sybase sql server?
Using large raw partitions with replication server on unix in sybase?
How do I pipe the output of isql to a file in sybase?
How do I open a sybase database?
Does table partitioning require user-defined segments in sybase?