DBAs - Do you turn on all the default alerts?

Loading last updated info...

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

Authors

Need help?

SSW Consulting has over 30 years of experience developing awesome software solutions.

We open source.Loving SSW Rules? Star us on GitHub. Star