0

We have a home-grown system of monitors and processes that generate events which are then gathered into a central instance and are sent as daily summary reports to operational DBAs via SSRS. It reports on anything from non-standard configuration, missing backups, disabled jobs that shouldn't be, databases in bad states, mirroring and AG issues, audit related issues (SOX), etc.

One of the things I am currently doing is writing a process that runs sp_Blitz on a weekly basis and generates events based on some of the findings.

Brent Ozar mentions that an Excel file with all of the possible CheckIDs is contained in the First Responder Kit download, and I can't find it in there. There is also a link on the sp_Blitz page that is supposed to link to it, but it points to a non-existent page on GitHub (I get a 404).

Does anyone know where I can find this document that contains every possible CheckID and its description?

1

Sure, it's in Markdown here: https://github.com/BrentOzarULTD/SQL-Server-First-Responder-Kit/blob/master/Documentation/sp_Blitz_Checks_by_Priority.md

If you find any inconsistencies with it, check out the Contributor Guide for how to open issues in the GitHub repo, discuss the changes you want to make, and check in changes.

3
  • Thanks, Brent. I am not sure if you fixed it, or i I am going crazy, but I just went back to the sp_Blitz page on your website and it now magically works. So... great! – Brettuss Mar 4 '20 at 19:56
  • Hey Brent, side question for you here - do you have a policy to not alter CheckIDs? We are building a process around the sp_Blitz results, but it would need to rely on the fact that CheckIDs don't change. CheckIDs going away is fine, but we want to make sure they woulnd't be changed and used for something else. – Brettuss Mar 19 '20 at 15:17
  • @Brettuss generally speaking, we try not to alter CheckIDs, yeah. – Brent Ozar Mar 19 '20 at 19:47

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.