cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 9

What are the SQL Server "Best Practices" for setting up Alerts

Hi folks,

Do you have any recommendations/guidelines or even best practices when it comes to setting up SQL Server Alerts? Have you come across some great alert configurations or must have alerts? So far I've got severity level 17 through to 25 for the error log, are there any other error log alerts or even alerts outside of the error log that I should have configured?

Any help would be greatly appreciated.


Thanks,


Michael Murray

Labels (1)
Tags (3)
0 Kudos
3 Replies
Level 12

I suggest monitoring SQLAgent and for failed SQLAgent jobs.  There are some errors you could monitor for that indicate corruption.  Error 823, 824 and 832.  Here are some links that may help. 

https://thwack.solarwinds.com/docs/DOC-172597?p=26

http://www.confio.com/logicalread/custom-ignite-alert-sql-server-job-failure/#.VE-l9fnF_5o

http://support.confio.com/p/sql-server-sql-agent-alert/30/

http://stackoverflow.com/questions/334650/sql-server-alerts-best-practices

Level 9

Thanks Brian, I currently have the SQL Jobs monitored through DPA and error log's with severity levels 17 through 25. What other handy alerts should I setup within DPA? (e.g. Data/Log file free space, blocking, etc...) and how do I configure these correctly without impacting server performance?

0 Kudos
Level 12

I just browsed through reports available online and here's ones, that as a DBA, I would consider.

Here's a couple of reports for blocking :

https://thwack.solarwinds.com/docs/DOC-174921

https://thwack.solarwinds.com/docs/DOC-173995

Here's a report that can help you find table scans : https://thwack.solarwinds.com/docs/DOC-173999

Here's a report that suggests indexes : https://thwack.solarwinds.com/docs/DOC-172615

Top Programs by day : https://thwack.solarwinds.com/docs/DOC-172612

Backup monitoring : https://thwack.solarwinds.com/docs/DOC-173994

Database Growth : https://thwack.solarwinds.com/docs/DOC-173354

*also requires this one: https://thwack.solarwinds.com/docs/DOC-173353

Long Running Queries: https://thwack.solarwinds.com/docs/DOC-172747