December 17, 2021 at 8:07 am
sp_BlitzFirst did not complete execution even after running it for more than 4 hours. I have tried executing it with no parameters and below parameters as well.
"exec sp_BlitzFirst @seconds=10,@expertmode=1,@blitzcacheskipanalysis=1"
We were able to run sp_Blitz succcessfully.How to make sure sp_BlitzFirst completes running?
Feel free to ask for more information if required.
Message Generted :
Setting up configuration variables
Now starting diagnostic analysis
Checking for Read intent databases to exclude
Determining SQL Server version.
Capturing first pass of wait stats, perfmon counters, file stats
Beginning investigatory queries
(No other message is seen)
Specifications:
sp_Blitz ver 8.07
SQL Server Standard 64 bit, 2017
16GB RAM alloted.
December 17, 2021 at 11:10 am
You would probably get the best response directly from Brent Ozar
December 17, 2021 at 3:11 pm
Hi,
Have a look at https://www.brentozar.com/archive/2021/11/video-office-hours-black-friday-edition-ask-me-anything-about-sql-server. It mentions a case of a slow running sp_BlitzFirst
I guess unless you pay Brent for it ( or use his consultant kit) , you'll have to find out yourself. When found post an issue on https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit
Usually I run sp_WhoIsActive first instead of spBlitzfirst
December 17, 2021 at 4:27 pm
Go look at the code itself. It getting hungup on something of yours might be an indication of something you've done seriously wrong to begin with.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply