SQL Server Community Tools: Detecting Memory Pressure In SQL Server With sp_PressureDetector


People are always surprised by how SQL Server uses, and misuses, memory. First, there are misconceptions about how much memory Standard Edition can use — everyone thinks it’s 128GB — but that’s just for the buffer pool.

Sometimes they …

Some Updates to sp_QuickieStore and sp_PressureDetector

In Trunks

I’ve made a few changes and improvements to these scripts. Here’s the changelog:


  • Improved introduction
  • Added help section
  • Changed column order to put DOP information next to thread usage information
  • Added reserved threads to the CPU