N-central Help

SQL Memory Manager service

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