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. |
Home » Performance Tuning » Other Important Performance Counters »