3.2 How to Fix Query Memory Waits (RESOURCE_SEMAPHORE)

RESOURCE_SEMAPHORE is what we call a poison wait: when it strikes, queries seem like they’re taking unpredictably long, and your server’s workload metrics (CPU, disk) don’t seem to match up to the demands of what folks are asking for from the database. It all has to do with how much memory queries ask for, and…

To access this incredible, amazing content, you gotta get Mastering Server Tuning with Wait Stats or Recorded Class Season Pass, or log in if you already shelled out the cash.