Answer the following questions about your data:
How many tables contain highly critical data?
How often does that data change?
How large are those tables?
dbcc checkstorage is a database-level operation. If only a few tables contain critical data or data that changes often, you may want to run the table- and index-level dbcc commands more frequently on those tables than you run dbcc checkstorage on the entire database.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
