July 4, 2012
by
0 comments | 2,304 views

VN:RO [1.9.17_1161]

Number of unused indexes

Use this metric if you want to monitor the number of indexes per database that haven’t been used for the last month. Indexes that aren’t in use should be removed because they can degrade INSERT, UPDATE and DELETE performance, and they use storage space. Read more

July 4, 2012
by
0 comments | 5,584 views

VN:RO [1.9.17_1161]

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. Read more