SQL performance alerts

  • I'm looking to use SQL alerts to become more proactive in my problem solving by investigating the cause of the alerts as oppose to waiting for feedback that there is a problem. I have the standard error severity >16 alerts but am looking for some others possibly using the performance monitoring side of things. I know it all depends on the problems you have in your environment but would like to get a general feel for the alerts you use and what you use them for.

    Any suggestions?

    Thanks

  • I generally only create baseline of alerts for 824 and 825, then 19-25. I have used Glenn Berry's script[/url] at times to create these for me.

    Any other alerts outside of this are for specific purposes but I have not used any for performance reasons. Performance side of things I would suggest capturing that information over time (perf counters, wait stats, etc.) and then build your own procedures to alert off of that data. I do this for disk space and then databases with low log space.

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • If you do some searches there are several scripts for monitoring for blocked processes that's one I'd set up. Timing is different on every environment though. I'd also suggest getting alerts on deadlocks. Performance alerts other than those two are hard to suggest.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply