![[Table of Contents]](/dwicons/b_toc.gif)
|
System Administration Guide (Online Only)
|
To report statistics information
from dbcc_counter
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
![[-]](/dwicons/i_colpse.gif)