what is the difference between dbcc checkstorage and other
dbcc commands
Answers were Sorted based on User's Feedback
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 |
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 |
How to pad with leading zeros an int or smallint in sybase?
what means of sybase ?? and how i can use sybase data base on my computer Iam the first use it >> any help please !
Explain the difference between numeric and decimal data types in sybase.
what is the architechure of sybase ASE?
Can you create your own sps for system wise?
Can I partition any table in sybase ?
There is no space in file system and you need to take a back up. What will you do?
Differentiate between ltm and repagent?
What are the advantages that you can get from mainframe connect in sybase?
Is sybase a database? Explain.
What are table partitions? How is it different with ase 15.0 version?
Explain coalesce. What is the equivalent of oracle/db2 coalesce function in sybase?