DBAs - Do you turn on all the default alerts?

Last updated by SSW.Rules.SharePointExtractor almost 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


Adam Cogan
We open source.Loving SSW Rules? Star us on GitHub. Star
Stand by... we're migrating this site to TinaCMS