sp_dbcc_statisticsreport reports statistics information from the dbcc_counter table generated by dbcc checkstorage on or before the specified date. The following example shows output from this command:
sp_dbcc_statisticsreport 'sybsystemprocs', 'sysobjects'
Statistics Report on object sysobjects in database sybsystemprocs Parameter Name Index Id Value ----------------- -------- ----------- count 0 160.0 max size 0 99.0 max count 0 16.0 bytes data 0 12829.0 bytes used 0 15228.0 count 1 16.0 max size 1 9.0 max level 1 0.0 max count 1 16.0 bytes data 1 64.0 bytes used 1 176.0 count 2 166.0 max level 2 1.0 max size 2 39.0 max count 2 48.0 bytes data 2 3092.0 bytes used 2 4988.0 Parameter Name Index Id Partition Value Dev_name ---------------------- -------- --------- -------- ---------------- page gaps 0 1 16.0 master pages used 0 1 17.0 master extents used 0 1 3.0 master overflow pages 0 1 0.0 master pages overhead 0 1 1.0 master pages reserved 0 1 6.0 master page extent gaps 0 1 7.0 master ws buffer crosses 0 1 7.0 master page extent crosses 0 1 7.0 master page gaps 1 1 1.0 master pages used 1 1 2.0 master extents used 1 1 1.0 master overflow pages 1 1 0.0 master pages overhead 1 1 1.0 master pages reserved 1 1 6.0 master page extent gaps 1 1 0.0 master ws buffer crosses 1 1 0.0 master page extent crosses 1 1 0.0 master page gaps 2 1 5.0 master pages used 2 1 8.0 master extents used 2 1 1.0 master overflow pages 2 1 0.0 master pages overhead 2 1 1.0 master pages reserved 2 1 0.0 master page extent gaps 2 1 0.0 master ws buffer crosses 2 1 0.0 master page extent crosses 2 1 0.0 master
