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.

Improve this question
0

1 Answer 1

Reset to default
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.

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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