The dbcc checkstorage command:
Combines many of the checks provided by the other dbcc commands
Does not lock tables or pages for extended periods, which allows dbcc to locate errors accurately while allowing concurrent update activity
Scales linearly with the aggregate I/O throughput
Separates the functions of checking and reporting, which allows custom evaluation and report generation
Provides a detailed description of space usage in the target database
Records dbcc checkstorage activity and results in the dbccdb database, which allows trend analysis and provides a source of accurate diagnostic information
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
