0

I want to run sp_Blitz and other scripts (from first aid) on a busy primary production server.

There are 75 databases on the server, of which 40 are in an availability group (synchronous, no read scale).

I am reading the readme file which says @BringThePain = 1 - required if you want to run @CheckUserDatabaseObjects = 1 with over 50 databases. It's gonna be slow.

The term pain is scary and so I want to ask whether the pain is in terms of the time that I have to wait to get the response from the stored proc or does pain mean that its going to cause blocking/slow production workload on the sql server?

3
  • 2
    The queries will take resources to run, but they don't do anything that should cause locks/blocking on your user databases. It's mostly, as far as I can tell, about the time you'll have to wait. Unless your server is regularly out of CPU resources it should just be you inconvenienced by it.
    – TZHX
    May 4, 2022 at 10:21
  • This is available in the documentation. @BringThePain = 1 - required if you want to run @CheckUserDatabaseObjects = 1 with over 50 databases. It's gonna be slow. May 4, 2022 at 12:44
  • Yes I have seen that but wanted to be sure because the word pain didn't sound quite nice.
    – variable
    May 4, 2022 at 12:54

1 Answer 1

2

Yes, it will slow down both its own session, plus add additional overhead to the server.

There's no way to add load to one person without also affecting other users on the server.

Your Answer

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

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