SQLConfiguration SQLConfiguration


Monitoring SQL  «Prev 

Monitoring with dbcc and dbcc buffer

For all of the dbcc buffer options, you will receive header information describing the page being displayed. If you have more than one page, you will see the BUFFER block and PAGE HEADER information for each page.

With the display option 1 you will see each data record for the table on the pages returned. SQL Server also displays a row offset table, showing where each row is located in memory if you specify an object.

With the display option 2, SQL Server returns a memory dump of the pages containing the object. SQL Server also displays a row offset table, showing where each row is located in memory if you specify an object.

With the display option 3, SQL Server returns a memory dump of the pages containing the object, separated into records. SQL Server also interprets the records, displaying the information in a more readable format.