sp_dbcc_differentialreport compares the results of the dbcc checkstorage operations completed for the specified database object on the specified dates. The following example shows output from this command:
sp_dbcc_differentialreport master, sysprocedures, checkstorage, "01/01/96", "01/02/96"
The following changes in dbcc counter values for the object "sysprocedures" in database master have been noticed between 01/01/96 and 01/02/96. Description Date1 Date2 pages used 999 1020 pages reserved 1000 1024 page extent gaps 64 67
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
