Reporting a Summary of dbcc checkstorage Operations

sp_dbcc_summaryreport reports all dbcc checkstorage operations that were completed for the specified database on or before the specified date.

The following example shows sp_dbcc_summaryreport output:

sp_dbcc_summaryreport
DBCC Operation : checkstorage
Database Name      Start time           End Time   Operation ID
         Hard Faults Soft Faults Text Columns Abort Count
         User Name                      
------------------ -------------------- ---------- ------------ 
         ----------- ----------- ------------ ----------- 
         ------------------------------ 
sybsystemprocs     05/12/1997 10:54:45  10:54:53              1
         0           0            0           0
     sa                             
sybsystemprocs     05/12/1997 11:14:10  11:14:19              2
         0           0            0           0
     sa

See Reference Manual: Procedures > dbcc Stored Procedures.