Does sp_Blitz @BringThePain parameter cause pain for the user (delay) or the server (blocking/slowing production workload)?



  • 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?



  • 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.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2