First Responder Kit Updates: New Checks Across the Board

Last Updated 7 years ago

It’s the December to Remember Script Event, and we’ve got updates to everything. Shout out to our contributors this month: @BlitzErik, @RichBenner, @runamuk0, @SQLMonger, and @BrentOzar.

Grab the newly updated First Responder Kit, and here’s what’s in it:

#591 – add check for 2016 Standard installed without Service Pack 1 (coded by @RichBenner)
#615 – add check for trace flag 834 used in combination with columnstore indexes (coded by @RichBenner)
#603 – add check for min server memory = max server memory (suggested by @BlitzErik, coded by @RichBenner)
#598 – added checks for non-default database configuration scoped settings in SQL 2016 (suggested by @HenrikStaunPoulsen, coded by @BrentOzar)
#593 – added check for Instant File Initialization using new sys.dm_server_services field in SQL 2016 SP1 (suggested by @BlitzErik, coded by @BrentOzar)
#592 – added check for Lock Pages in Memory using new sys.dm_os_sys_info field in SQL 2016 SP1 (suggested by @BlitzErik, coded by @BrentOzar)
#582 – added check for TempDB file creation error (suggested by @BlitzErik, coded by @BrentOzar)
#616 – improved Target Recovery Time warning because some SQL tools set it to 0 and some set it to 60 (suggested by @aclenscorp, coded by @BrentOzar)
#619 – fixed case sensitivity bug introduced in another patch (coded by @mikejwhitty, only visible to folks like us who work in the dev branch)

#617 – add alert for computed columns with scalar operators (coded by @BlitzErik)
#626 – add alerts for more kinds of expensive remote queries (coded by @BlitzErik)
#228 – skip offline databases (coded by @BlitzErik)

#599 – made it more PowerShell-friendly by making all column names unique in the FileStats column output (coded by @runamuk0)

#615 – added warning if trace flag 834 is used in combination with columnstore indexes (coded by @RichBenner)
#622 – stop counting hypothetical indexes in the total number of indexes on a table (coded by @BlitzErik)
#607 – now works in partially contained databases (reported and fixed by @SQLMonger)

#544 – added database name in the output to show the query’s context (coded by @BlitzErik)