Monitoring SQL  «Prev  Next»

Lesson 8 Monitoring with dbcc, continued
Objective Use dbcc buffer to monitor the Data Cache

Use dbcc buffer to monitor Data Cache

dbcc buffer

The dbcc buffer command is used to look at the SQL Servers data cache. You can see all of the cache, including the cache for a specific database, for a specific object, or a given number of pages. You also have the capability of controlling the number of pages returned.
This dbcc command is not documented by Microsoft and should use your own judgement when using the command.
The syntax of the dbcc buffer command is as follows:
dbcc buffer [(dbname|db_id [,object_name|objectid [,number of pages [ ,display option]]] )]

Buffer Page Header

dbcc buffer
When dbcc buffer returns information, it returns the most recently used (MRU)[1] page first; unless the number of pages is less than 0, then it returns the least recently used (LRU) page first. The display option can be 0 (default), 1, 2, or 3. The following SlideShow illustrates the output of the dbcc buffer command.
Least recently used (LRU): The in memory data page that has gone the longest time without being accessed.
In the next lesson, you will learn about three more methods for using dbcc to monitor SQL Server performance.
[1]Most recently used (MRU): The in memory data page that was the last data page to be accessed.