SQL Memory Manager service
When this service has a scan interval of less than 5 minutes, the agent may take longer than the scan interval to gather the metrics. As a result, you may notice some scan intervals are not populated.
The SQL Memory Manager service monitors various aspects of how an SQL Server uses memory.
| Service Type | WMI |
| Instances on a Device | 3 |
| Supported Systems/Applications | Microsoft SQL Server |
| Device Class | Server - Generic, Workstation - Generic, Other, Printer, Scanner/Camera, Switch/Router, Laptop - Windows, Server - Windows, and Workstation - Windows |
| Monitored By | Windows agent |
| Scan Interval | 15 minutes |
| Minimum Scan Interval | 1 minute |
| SQL Server Instance | The specific instance of the SQL Server database engine that is running on the target server. |
| Status Detail | Description |
|---|---|
| Connections Memory (KB) | The total amount of dynamic memory that the server is using for maintaining connections. |
| Lock Memory (KB) | The total amount of dynamic memory that the server is using for locks. |
| Optimizer Memory (KB) | The total amount of dynamic memory on the server that is being used for query optimization. |
| SQL Cache Memory (KB) | The total amount of dynamic memory that the server is using for the dynamic SQL plan cache. |
| Total Server Memory (KB) | The amount of memory that the server has committed using the memory manager. |
| Memory Grants Pending | The total number of processes that are waiting for a workspace memory grant. |