We have a website for SolarWinds Orion which utilizes SQL and we've had many reports of slowness issues with the website. I ran sp_Blitz on the SQL box and I'm seeing these errors:
Poison Wait Detected: RESOURCE_SEMAPHORE 98:07:56:03 of this wait have been recorded. This wait often indicates killer performance problems.
Poison Wait Detected: RESOURCE_SEMAPHORE_QUERY_COMPILE 33:06:03:08 of this wait have been recorded. This wait often indicates killer performance problems.
Too Much Free Memory 7GB of free memory inside SQL Server's buffer pool, which is 12GB. You would think lots of free memory would be good, but check out the URL for more information.
The server has been provisioned 16GB of RAM and SQL server is configured to use 13GB of maximum server memory, 1024KB per query. Is this server over provisioned? I feel like its a memory misconfiguration but any assistance or insight would be appreciated.