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 is the default table size in sybase?
Is there any advantage of last_name varchar(50) over this last_name varchar(255)?
How to take backup in sybase database in sap?
How to save space when inserting rows monotonically?
How would you fix a munged log in sybase ?
What is the relationship between jdbc and sybase?
What is replication server?
What is ceiling()?
What is the difference in storage type of numeric and decimal data types in sybase ?
What is trace flags — 5101 and 5102 in sybase?
Explain procedure cache and data cache in sybase.
How can I execute dynamic sql with ase in sybase?
Is sybase open source?
What is the drawbacks of normalization?
Must I use multiple devices to take advantage of partitions in sybase?