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!

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.



5 thoughts on “Updates to sp_PressureDetector and WhatsUpMemory

  1. 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)

  2. 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

    1. It’s fairly safe if you turn the sound off. But try it out on a developer that likes to code NOLOCK everywhere first.

Comments are closed.