Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag Top buffer cache object Rss

   Items 1 to 1 of 1   

SQL Monitor Custom Metric: Top Buffer Cache Object

This metric measures the amount of memory used in the buffer cache by the largest object (based on the number of pages). It checks the sys.dm_os_buffer_descriptors to identify the object, and returns the relative percentage used. You should use this metric if you want to monitor what is in the buffer area, or if you are having performance-related disk read problems.  Read more...
By Press Release 2013/07/22 | Source: Redgate | Category: top buffer cache object
Rating: (not yet rated)  Rate this |   Briefcase | 3,198 reads
   Items 1 to 1 of 1