During the quarantines, I’m looking for new ways to help you level up for free.
I decided to start live-streaming whenever I’m working on things I can share with you publicly. I wanted to add a new check to sp_Blitz, so I figured I’d do it live on camera while you watch, and talk you through my thought process.
In this 52-minute video, you’ll see me working in Azure Data Studio and Github as I explain why it’s hard to add DMV-related checks since SQL Server’s available columns change over time. I end up using dynamic SQL to make it work on both SQL Server 2008 and 2012+.
Related links to keep the training going:
- The Github issue I’m working on: #2134: sp_Blitz and sp_BlitzFirst: add warning about high USERSTORE_TOKENPERM cache size
- sys.dm_os_memory_clerks – the DMV whose contents changed over time
- When the USERSTORE_TOKENPERM Cache Stops You From Caching Query Plans – the problem I’m alerting folks about. This page has several related reading links, too.
- A Tourist’s Guide to the sp_Blitz Source Code
- How to fork a GitHub repository and contribute to an open source project by Rob Sewell – in case you’d like to contribute to an open source project
I’m not going to schedule these ad-hoc live streams ahead of time – it’s just whenever they fit into my schedule – but if you want to be alerted when I start broadcasting, here’s how – I live stream simultaneously in all of these places: