A Centralized Reporting Database for SQL Server Agent Alerts
SQL SATURDAY Richmond 2020 Viewers:
Im sorry I couldnt make my presentation on April 25 as all 3! of my Win10 PCs
decided to lock down security on the camera and mic and kill the Settings App with nonstop GPFaults
Finally did reinstall and finished by 5pm
But where is the Mac server with 480 cores? - Nowhere
SQL Server can handle it:
https://channel9.msdn.com/Events/Ignite/2015/BRK2558
SQL Saturday Presentation Demo is here:
https://www.sqlsaturday.com/962/Sessions/Details.aspx?sid=101121
The default functionality for the SQL Agent is to only Send an Email upon the firing of an Agent Alert
This code will allow you to capture all those Alerts from all your SQL Servers into a Central Reporting Database
Some popular and recommended Alerts are:
- Error Number 17883 - Non-Yielding Worker Process
- Error Number 1205 - Transaction Deadlock
- Error Number 17890 - Most SQL process memory paged out
- Error Number 18204 - Backup Failed
- Error Number 833 - Slow IO
Setup instructions in each Subfolder above
- Setup the Central SQL Server that will hold all the Alerts from all the other SQL Servers you want to monitor
- Setup the Monitored Servers by installing an Agent Job that calls the Powershell script passing in the Alert params
- Use My/Write your own SSRS/PowerBI reports to surface your SQL Estate-Wide alerts
All Code is Powershell, TSQL
Includes both SSRS and PowerBI Reports