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.
