I am a heading
Over the past month (plus or minus a couple days), I’ve shown you in a series of quick posts how I use different SQL Server Community Tools that are free and open source to troubleshoot SQL …
Category: sp_PressureDetector
SQL Server Community Tools: Why Does sp_PressureDetector Make A Big Deal About The Remote DAC?
Subject Matter
I’m gonna throw this at you fast, because it’s Friday. If you’re using sp_PressureDetector in a SQL Server performance crisis, there are two things you don’t want:
- Slow results from running diagnostic queries
- Diagnostic queries waiting in the
SQL Server Community Tools: sp_PressureDetector Doesn’t Show You Irrelevant Waits
Which Wait Did They Go?
I tried to really focus sp_PressureDetector on things that really matter to overall SQL Server performance, and specifically related to CPU and memory pressure.
It seemed easier to include rather than exclude waits, since the …
SQL Server Community Tools: sp_PressureDetector Shows You Running Queries Taking Up CPU And Memory
One For The Money
This post describes a little more of the philosophy behind sp_PressureDetector more than anything technical about it. Maybe.
I write this at the outset, but who knows where it’ll end up. Might even delete the whole …
SQL Server Community Tools: Detecting Memory Pressure In SQL Server With sp_PressureDetector
Sponsor
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 …
SQL Server Community Tools: Detecting CPU Pressure In SQL Server With sp_PressureDetector
Playing Favorites
I absolutely adore sp_PressureDetector. It’s short, it’s sweet, and it returns so many great details about what sort of pressure a SQL Server is under.
Today, we’re going to look at various ways that CPU pressure can …
Updates To sp_PressureDetector
All Good Things
I haven’t run into a bug with this thing in just about… Well, ever. This proc has been pretty solid.
As I use it though, especially in front of clients, I find myself wanting some additional data …
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 …
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
Updates to sp_QuickieStore, sp_PressureDetector, and sp_HumanEvents
A Thing Of Things
- Added the ability to search query store wait stats for queries that generated a large amount of a specific wait category.
- Noticed a couple
TOPqueries were missingDESCfor the ordering - Increased length of