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.
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.
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?
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 :
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
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.