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
$2,495.00 Original price was: $2,495.00.$990.00Current price is: $990.00.
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:
- Demo video MP4 (about 8 minutes, 100MB)
- Demo code zip file
- FGCB_ADD_REMOVE entry in my waits/latches library
- 2021 article from the old SQLPerformance.com I wrote with more background
Enjoy!
(PS It’s also doubling as the video demo for this week’s SQLskills Insider newsletter)
