0

I am running sp_Blitz on my SQL Server 2014 with 93 databases. It has been running for more than 5 hours and still won't complete. I am able to run sp_BlitzWho,sp_BlitzIndex,sp_BlitzFirst and sp_Blitzbackup and they all take about 2-3 minutes to complete.

I wonder why is it (sp_Blitz) running too long and still not providing any results.

Results for sp_blitzwho and sp_whoisactive

Alekhya
  • 1
  • 2
  • 3
    Try the @CheckUserDatabaseObjects = 0 parameter. – Brent Ozar Apr 13 '19 at 17:27
  • Makes sense to track a long-running query, perhaps it blocked by some other process. There are plenty of ways of how to do it, for instance by using another great third party procedure: sp_whoisactive (available here: http://whoisactive.com/) – Alexander Volok Apr 13 '19 at 17:48
  • @BrentOzar, I tried CheckUserDatabaseObjects = 0 parameter. It is still taking too long and not providing any results. Please suggest if there is any other way. Please find the results for sp_blitzwho as an attachment in my post for reference. Thanks for all the guidance in advance. – Alekhya Apr 15 '19 at 14:41
  • @AlexanderVolok please find the results for sp_whoisactiveas an attachment in my main post for reference and please suggest. Thanks in advance. – Alekhya Apr 15 '19 at 14:58
  • 1
    @Alekhya, you need to click on session 85 column `sql_text`, this will open an actual query on a separate tab, so you can analyze it – Alexander Volok Apr 15 '19 at 15:16

0 Answers0