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 …
Category: sp_PressureDetector
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
Detecting Memory Cache Pressure In SQL Server With sp_PressureDetector
Cache Rules
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. I’m also available …
Updates To sp_PressureDetector
These Colors Don’t Gum
If you head to my GitHub repo, there’s an update to sp_PressureDetector, a free script I publish to help you figure out when your server is under CPU or memory pressure.
While working with …
Updates to sp_PressureDetector and WhatsUpMemory
GIRTFT
Just a couple minor updates:
- sp_PressureDetector now includes statement start and end offsets, in case you want to build plan guides for queries
- WhatsUpMemory got a huge performance tuning, which I’ll talk about in tomorrow’s post!
Nothing else here. …
Updates To sp_HumanEvents and sp_PressureDetector And More!
Ain’t Nothing To Do
I’ve made some changes to my scripts! Exciting. Sorta. Kinda.
sp_PressureDetector
Got a name change. The code hasn’t changed at all. I started getting annoyed by the formatting and the underscore between pressure and detector.
Now …