First Responder Kit Release: Treating Object References Like Object Instances, Man

Object reference not set to an instance of an object.

You can download the updated FirstResponderKit.zip here.

sp_Blitz Improvements

  • #1281 We’ve lowered the priority of Query Store being disabled. It’s just not as important as the backups you’re not taking and the corruption checks you’re not running.

sp_BlitzCache Improvements

  • #1253 Due to an unfortunate copy and paste incident, the rolled up warnings about index spools were both looking at the same flag column. That has been fixed. Thanks to @jobbish-sql for letting us know!
  • #1256 We’ve improved the handling of many indexes being modified to be more accurate. Less wrong. Ahem. Thanks to @JimmyParker for reporting this one.
  • #1261 Added a new clickable column that presents ALL missing index requests for a query in order of estimated impact. Only fires when a missing index has an impact of > 70%. Beat that, SSMS.
  • #1316 More work to tidy up the implicit conversion and compiled value clickable columns.

sp_BlitzFirst Improvements

Nothing this time around

sp_BlitzIndex Improvements

  • #1138 The aggressive lock warning was showing the incorrect number of nonclustered indexes
  • #1149 Adds an index on #IndexColumns that can maybe probably kinda help improvement when this table has a lot of objects in it. Thanks to @SAinCA for letting us know!
  • #1311 If we report that your Heaps (HEAPs? heaps?) have forwarded records in them, we supply you with the REBUILD command to fix them. Now you don’t have to go lookup the REBUILD command to fix them.

sp_BlitzWho Improvements

  • #1188 We have pruned the default columns shown! If you want to see all of the columns, you need to use @ExpertMode = 1
  • #1203 There were two columns named used_memory_kb from two different tables. We’ve clarified their origins. Thanks to @hfleitas for letting us know!
  • #1255 If you’re using context info, we’ll display that in the aforementioned expert mode. This sounds like expert stuff. Thanks to @eaglejohn81 for the request, and @SQLGumbo for writing the code and tests!

sp_DatabaseRestore Improvements

  • #1152 We can now put a database into Standby after doing log restores. Thanks to @James-DBA-Anderson for the idea and code!
  • #1242 We now throw and error when credentials to a mapped drive are incorrect.

sp_BlitzBackups Improvements

Nothing this time around

sp_BlitzQueryStore Improvements

All the same stuff as sp_BlitzCache

sp_AllNightLog and sp_AllNightLog_Setup Improvements

  • #1242 We also try to catch invalid credentials here
  • #1243 Removes a faulty where clause that prevented some backups and restores from being triggered

sp_foreachdb Improvements

  • #1318 @amtwo taught this old dog a new trick. It’s now AG aware, and won’t try to run commands on databases that are online but aren’t accepting connections.

PowerBI

  • #1257 We were missing some time slices. Now we’re not. Thanks to @tcartwright for letting us know and contributing a fix!
  • #1236 Now the Power BI Dashboard for DBAs prompts you for the server name & database when you open it.

sp_BlitzLock

We’ve got a new family member. This will examine the system health or a custom extended event session that captures deadlocks. 2012+ only. Blog posts about usage to follow. For now, head over to the GitHub documentation.

For Support

When you have questions about how the tools work, talk with the community in the #FirstResponderKit Slack channel. If you need a free invite, hit SQLslack.com. Be patient – it’s staffed with volunteers who have day jobs, heh.
When you find a bug or want something changed, read the contributing.md file.

When you have a question about what the scripts found, first make sure you read the “More Details” URL for any warning you find. We put a lot of work into documentation, and we wouldn’t want someone to yell at you to go read the fine manual. After that, when you’ve still got questions about how something works in SQL Server, post a question at DBA.StackExchange.com and the community (that includes us!) will help. Include exact errors and any applicable screenshots, your SQL Server version number (including the build #), and the version of the tool you’re working with.

You can download the updated FirstResponderKit.zip here.

Previous Post
Contest: Guess the SQL Server 2019 Release Date
Next Post
Index Maintenance Madness

4 Comments. Leave new

  • In Sp_Blitz the link for https://BrentOzar.com/go/virtual appears to be broken. It also doesn’t appear to be able to determine a VM is Windows Server 2016 for some reason? (“I have no idea which version of Windows You’re on. Sorry.”)

    • Jay — for support, please use our GitHub repo. We can’t really do this stuff in blog comments.

      Thanks!

  • If you are running a SQL failover cluster with Clustered Shared Volumes, spBlitz thinks all datafiles are on C: drive.

    • Neil – great news! The scripts are entirely open source, so you can fix that. None of us have that setup to test stuff out on, so you’re the guy for the job 😉

      Head on over to the GitHub repo when you’re ready to contribute code.

      Thanks!

Menu
{"cart_token":"","hash":"","cart_data":""}