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!
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 to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that and need to solve performance problems quickly.
WhatsUpMemory is a LOT faster. I played with the last iteration and recalled it took a small eternity, almost like being on stage with Yoko Ono. (Zappa inside joke and liner note, dammit)
Yeah! It was really frustrating. Like obscure jokes. ?
I really wanted to spare you the horrors. So be it.
Don’t do it, man!
Don’t!
Really!
I’m warning you.
God help you.
Sign this waiver first, please.
A Small Eternity With Yoko Ono (Live At Fillmore East, NYC, 1971)
https://youtu.be/CZYC4OB3ECc?t=120
My lawyers have advised me not to click on that.
It’s fairly safe if you turn the sound off. But try it out on a developer that likes to code NOLOCK everywhere first.