what is the difference between dbcc checkstorage and other
dbcc commands

Answers were Sorted based on User's Feedback



what is the difference between dbcc checkstorage and other dbcc commands..

Answer / 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

what is the difference between dbcc checkstorage and other dbcc commands..

Answer / 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

More Sybase Interview Questions

Differentiate between ltm and repagent?

0 Answers  


What is asa in sybase?

0 Answers  


Explain asa, asa ultralite.

0 Answers  


You need to purge data from audit database. What will you do?

0 Answers  


What will happen if we create more indexes on a sysbase iq table?

1 Answers  


How to compute database fragmentation in sybase?

0 Answers  


Why do my page locks not get escalated to a table lock after 200 locks?

0 Answers  


How do I exclude a column in sybase?

0 Answers  


In sybase, we can have multiple users associated to same login ,each corresponds to different databases, right? how can we login to one database with corresponding user id?

3 Answers   ISRO,


Explain autosys. Why do you need it.

0 Answers  


Which version of open client works with which ase in sybase?

0 Answers  


What is sybase replication server?

0 Answers  


Categories