2

I'm trying to run sp_blitz on SQL Server 2014 and it seems to be taking a long time. What is the normal length?

We only have around 30 databases. One is 300GB, but it's going on for 15 min.

5

Can be anywhere from 5 seconds to 15 minutes depending on your server, workloads, databases, etc. If you have thousands of databases, for example, you can check out the documentation and use switches like @CheckUserDatabaseObjects = 0 to go faster by skipping stuff.

  • Think I just broke a record for the script, took 49 mins , 40 secs on one of my SQL Servers :) – Philip Oct 17 '18 at 4:40

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.