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