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_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’.
22 Comments. Leave new
Fantastic. Thank you for making these!
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.
🙂
Hahaha…
But seriously, we had an enjoyable few minutes playing with that feature after I saw it on your video 🙂
How long does sp_blitz take to complete?
Can depend on your server, workload, number of databases, etc.
Great tools. Many thanks for sharing!
Thank you Brent for the lessons.
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.
No, since the same query could be run many times in different sessions.
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?
Yep, I cover that in depth in my Mastering Query Tuning class.
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?
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.
Thanks, Brent! This helped me today!
Will it work on azure Sql database as well, I tried on our server that’s is paas but there is getting error in execution.
Please let me know if for azure Sql we have different version of sp_Blitz?
Read the documentation. Thanks!
There are several databases that are offline on one of our servers. sp_BlitzFirst doesn’t seem to like that, because it fails whenever it is run. Any ideas?
Hi Brent,
very helpful scripts, except customers tend to ignore the results 🙁
Is there an option to exclude Databases when running sp_BlitzCache? I only found the parameter to specify databases which should be checked…
Best regards
Guenter
I know, right? It’s like how customers ignore the readme that they get with open source scripts on where to get support. 😀
How do I run sp_BlitzLock on SQL Managed Instance?
For support, hit the readme file that comes with the scripts.