To report 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 output from this command:

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

For details, see Chapter 10, “dbcc Stored Procedures,” in the Reference Manual.