Home » Performance Tuning » SQL Server Memory » SQL Server: Memory Manager Counters

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.

1 thought on “SQL Server: Memory Manager Counters”

  1. Hi there, just became alert to your blog through Google, and
    found that it is truly informative. I’ll be grateful if you continue this in future. Numerous people will be benefited from your writing. Cheers!

Leave a Reply

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