DBAs - Do you turn on all the default alerts?

Updated by ChristianMWaite 5 years ago. See history

123

SQL Alerts are valuable because they can alert administrators of imminent SQL Server failures. e.g. when the msdb log file is full. To enable, you should change the settings under SQL Server Agent. SQL has no default alerts. You will have to create them, and I recommend that you add all the fatal level exceptions to alerts.

Image

Figure: SQL Alerts - We recommend that you add the fatal exceptions as alerts

acknowledgements
related rules