Collect SQLServer:Memory Manager counters.
This would be especially useful for SQL 2012 where counters have been removed from the buffer manager exist in the memory manager counters. For SQL Server 2012, I have observed that there is a memory leak and this is revealed by observing the Memory Manager Optimizer Memory (KB) counter.
Hi, we’re monitoring a few of those out of the box and the rest can be covered via the custom metrics feature – check out sys.dm_os_performance_counters
-
Hi Don,
Thanks for your suggestion. We will review this soon but for the time being you can use 'Custom metric' feature to start monitoring this particular counter.
Thanks,
Priya