Learn to Use sp_Blitz, sp_BlitzCache, sp_BlitzFirst, and sp_BlitzIndex with These Tutorial Videos

There have been so many improvements lately to our First Responder Kit scripts that it was time to update our tutorial videos. Each of these is about ten minutes long and shows how to use ’em:

How to Use sp_Blitz for a Health Check

How to Use sp_BlitzFirst in a Performance Emergency

How to Use sp_BlitzCache to Find Slow Queries

How to Use sp_BlitzIndex to Check Your Indexes

Download the free First Responder Kit and start making your SQL Server healthier.

And oh yeah, there may also be a little surprise hidden in the sp_BlitzCache video. Just sayin’.

Previous Post
[Video] Office Hours 2016/09/07 (With Transcriptions)
Next Post
Announcing PasteThePlan.com: An Easier Way to Share Execution Plans

14 Comments. Leave new

  • Fantastic. Thank you for making these!

    Reply
  • Brent, we need your postal address so we can mail you an invoice for all the time we lost playing with sp_BlitzFirst @Question. We ended up having an impromptu contest related to adding answers. Our boss is mad. He wants to be paid.

    🙂

    Reply
  • Nathan Briggs
    July 20, 2017 10:07 am

    How long does sp_blitz take to complete?

    Reply
  • Kevin Harrison
    May 30, 2018 9:03 am

    Great tools. Many thanks for sharing!

    Reply
  • Atang Mogwera
    June 14, 2018 9:24 am

    Thank you Brent for the lessons.

    Reply
  • Andrew Brodie
    March 11, 2019 12:38 pm

    Is there anyway to get the SPID using sp_Blitzcache for the offending queries or procedures. I’d like to map back exact calls with the runtime parameters so I can fully trace the issues.

    Reply
    • No, since the same query could be run many times in different sessions.

      Reply
      • Andrew Brodie
        March 11, 2019 1:12 pm

        That’s what I thought. My issue is that the procedure has different execution paths depending on the parameters, and can the stored execution plan can be misleading for subsequent executions, so we’ll have the procedure run fine, then poorly with different parameters forcing a different path. (I know rewrite the code!), but I’m not in charge 🙂 Any other insights on this scenario?

        Reply
  • Hi Brent,

    When I run the query EXEC sp_BlitzFirst @AsOf = ‘2019-09-19 11:17’, @OutputDatabaseName = ‘DBAtools’, @OutputSchemaName = ‘dbo’, @OutputTableName = ‘BlitzFirstResults’ I am getting the following error.

    Invalid object name ‘DBAtools.dbo.BlitzFirstResults’.

    Am I missing something here?

    Reply
    • Yep! The @AsOf parameter is for reading back in time in the BlitzFirstResults table, but that only works if you’ve already been logging to that table. If you haven’t logged to it before, you’ll need to read the documentation to set up the Agent job to create it and log to it.

      Reply

Leave a Reply

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

Fill out this field
Fill out this field
Please enter a valid email address.

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