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: these days I have AI do the annoying stuff for me. My new video course teaches you to work the same way, and I teach whole teams in a one-day workshop. Someone still has to know enough SQL Server to keep the robots in check, and that’s what my training is for.
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.