Thanks again for the helpful information. I was wondering if there is anything in the SQL Log that I should be monitoring with sp_readerrorlog that is outside of those alerts. I looked through our logs, and I didn't see anything outside of 'our' norm.. lots of I/O taking a long time to complete, but no one who can fix that is fixing it (i've sent tons of i/o metrics over the last year and an alert on that would just become daily/hourly noise).

I'm wondering if the sp_readerrorlog would be archaic to do, and I should just find a 3rd party tool that encapsulates all of that. BTW, this is on a DW, so most issues are low priority since we can recreate our DW to the previous day, versus OLTP.