Workload Performance Counters

S.NO Performance Counter Name Comments
16 SQL Server:Memory Manager – Optimizer Memory The amount of memory in KB that the server is using for query optimization. We need to have a steady value in this counter. A large variation in the value suggests there is lot of Dynamic SQL is getting executed.
17 SQL Server:Memory Manager – Connection Memory Amount of memory in KB used to maintain the connections.

Leave a Reply

Your email address will not be published. Required fields are marked *