Microsoft SQL Server DBCC DBCC informational statements
Example
DBCC commands can show information about database objects.
DBCC PROCCACHE
Displays information in a table format about the procedure cache.
DBCC OUTPUTBUFFER ( session_id [ , request_id ])
Returns the current output buffer in hexadecimal and ASCII format for the specified session_id (and optional request_id).
DBCC INPUTBUFFER ( session_id [ , request_id ])
Displays the last statement sent from a client to an instance of Microsoft SQL Server.
DBCC SHOW_STATISTICS ( table_or_indexed_view_name , column_statistic_or_index_name)
