FGCB_ADD_REMOVE Latch Investigation Demo

During the PASS Summit last week in Seattle I made a deal with my precon attendees that I’d record a couple of the demos in exchange for more time for questions and only running over ten minutes – sooooo many fantastic questions that took us down rabbit-holes into the internals!

As promised, here’s the first one.

Check It Out!

SQLskills Blackbelt Bundle and 2022 Updates - 1 Year Access

Original price was: $2,495.00.Current price is: $990.00.

View Course

It deals with investigating the FGCB_ADD_REMOVE latch using an XEvent session to watch the latches being acquired and dropped, showing the wasted time on the waiting threads and how to see which file in which database has the incorrect auto-growth setting.

Here are the pertinent links:

Enjoy!

(PS It’s also doubling as the video demo for this week’s SQLskills Insider newsletter)

Posted Under:

Leave a Reply

Your email address will not be published. Required fields are marked *

Other articles

AI Stories and Thoughts

iAI is obviously the hot new thing and prognostications for the future range from the unicorns-and-rainbows life of idleness for us all to the post-apocalyptic

Explore

Reflections on 15 Years

(This was the editorial for my 300th SQLskills Insider newsletter last week, that I’ve been producing since March 2011! See bottom of browser window to

Explore

Imagine feeling confident enough to handle whatever your database throws at you.

With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.