Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL performance alerts Expand / Collapse
Author
Message
Posted Saturday, August 16, 2014 2:49 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 8:46 AM
Points: 160, Visits: 153
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
Post #1604131
Posted Saturday, August 16, 2014 6:14 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 1:46 PM
Points: 947, Visits: 2,747
I generally only create baseline of alerts for 824 and 825, then 19-25. I have used Glenn Berry's script 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
PS C:\>(Find-Me).TwitterURL
@wsmelton
PS C:\>(Find-Me).BlogURL
meltondba.wordpress.com
Post #1604140
Posted Saturday, August 16, 2014 7:32 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 3:26 AM
Points: 14,205, Visits: 28,536
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
The Scary DBA
Author of:
SQL Server Query Performance Tuning
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1604141
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse