Adsense

Monday, March 23, 2015

Diagnosing RESOURCE_SEMAPHORE wait types

Diagnosing memory problems on SQL server can be difficult.  If you want to see if your SQL Server is running low on memory check out sys.dm_exec_query_memory_grants.  Checking the requested_memory_kb will show you the number of queries that are currently waiting on memory to be granted and how much memory they are requesting.


This is a useful query to use if you see a lot of waittypes of RESOURCE_SEMAPHORE.