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

I want deadlock notification using mail address and record stored in table. Expand / Collapse
Author
Message
Posted Friday, July 5, 2013 12:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 31, 2014 8:49 PM
Points: 8, Visits: 79
I want deadlock notification using mail address and record stored in table for mssql
Post #1470578
Posted Friday, July 5, 2013 1:20 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:22 AM
Points: 40,632, Visits: 37,094
Try using extended events.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1470603
Posted Friday, July 5, 2013 1:36 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 3:46 AM
Points: 608, Visits: 1,056
Also you can try setting "sql server performance condition alerts"

Pramod
SQL Server DBA | MCSA SQL Server 2012

in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/
Post #1470611
Posted Friday, July 5, 2013 1:38 AM
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 @ 10:01 AM
Points: 858, Visits: 2,509
or event notification with service broker
Post #1470613
Posted Friday, July 5, 2013 1:58 AM


SSC Eights!

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

Group: General Forum Members
Last Login: Friday, December 12, 2014 1:02 AM
Points: 823, Visits: 753
Eh, why? Deadlocks are nothing to be alarmed of as long as they are only occasional. If you have a deadlock each and every minute, you have a problem, but then you don't want mail about it.

Erland Sommarskog, SQL Server MVP, www.sommarskog.se
Post #1470619
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse