DBAs - Do you turn on all the default alerts?

Last updated by ChristianMWaite over 4 years ago.See history

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.

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

We open source. Powered by GitHub