SQL Server: Memory Manager Counters

Troubleshooting a SQL Server with Memory Manager Performance Counters

The areas we need to look at are for Memory (per process) related issues are:

Granted Workspace Memory (KB)-Total amount of memory currently granted to executing processes such as hash,sort, bulk copy, and index creation operations.

Maximum Workspace Memory (KB)-Maximum amount of memory available for executing processes such as hash,sort, bulk copy, and index creation operations.

Memory Grants Outstanding-Total number of processes per second that have successfully acquired a workspace memory grant.

Memory Grants Pending-Total number of processes per second waiting for a workspace memory grant. Numbers higher than 0 indicate a lack of memory.

Target Server Memory(KB)-Total amount of dynamic memory the server can consume.

Leave a Reply

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