Category: sp_PressureDetector
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 a client recently, I found it useful to illustrate how much of their memory was used by different memory consumers.
- Buffer pool
- Total other
- Top 5 other
It helps put in perspective just how many different things are asking for a piece of your precious RAM.
This is a bad example from my personal server laptop, but you get the idea.
Anyway, that’s that. clink over to my GitHub repo to download it.
Thanks for reading!
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. Happy downloading and analyzing.
Or analysing, if you’re from a refined country.
Thanks for reading!