You have a monitoring tool, but you’ve set up an email rule to dump all the alerts into a folder.
You’re not particularly proud of that, but it is what it is. You’re just tired of the spam.
But when you get in in the morning, you want a simple screen that shows you if anything is really and truly broken in your environment.
Step 2: start a group query. Right-click on the group of servers, and click New Query.
Step 3: run sp_Blitz @IgnorePrioritiesAbove = 50, @CheckUserDatabaseObjects = 0. This gets you the fast headline news, especially when used with the improved priorities in the latest version in our SQL Server download kit:
You’ll discover when:
- Corruption has been detected
- Databases in full recovery mode aren’t getting log backups
- You’re running a known dangerous build of SQL Server
- Poison waits have struck
- And much more
On Monday mornings, start here. I know, you’re probably not going to find anything, because your servers are in flawless shape and nothing ever goes wrong.
But just in case….