Updates To sp_PressureDetector: Crucial Wait Stats, More Consistent Column Arrangement, And More!

A Mother’s Guilt

GitHub had been making me feel guilty about taking some time off over the holidays to not monkey about with T-SQL, and since my brain finally seems to be working after a hectic travel schedule, I decided to tweak a few things in sp_PressureDetector.

What’d I change? Great question! There’s a preview in yesterday’s post, but here’s the change log:

• Formatting, of course
• Clarify memory rollup column names
• Add a section with wait stats overview for related cpu/memory/disk waits
• Add query text column to memory grant results
• Make query txt columns xml clickables
• Rearranged columns for readability and consistency
• Added a couple comments to clarify code intent
• Add Max Server Memory to the total/available/granted line

You can learn more about how to use sp_PressureDetector here. Happy troubleshooting.

Thanks for reading!

Going Further

If this is the kind of SQL Server stuff you love learning about, you’ll love my training. Blog readers get 25% off the Everything Bundle — over 100 hours of performance tuning content. Need hands-on help? I offer consulting engagements from targeted investigations to ongoing retainers. Want a quick sanity check before committing to a full engagement? Schedule a call — no commitment required.