Alert on Deadlock
-
I have created an SQL Agent Alert which should notify me whenever
a deadlock is occured on sql server. The following are the details:
Type : Performance Condition Alert
Object : SQLServerLocks
Counter : Number of deadlocks/sec
Instance: Database
Alert : If counter value rises above 0
I got deadlock situation a couple of times on server but i have never received any notification. It seems this settings doenot work. Pls. advise!
Thanks
-
Have you set the query wait time using sp_configure?
Also, check this KB
http://msdn2.microsoft.com/en-us/library/aa937573(SQL.80).aspx
--------------------
Colt 45 - the original point and click interface
-
Its the default of -1. I just want to setup deadlock alert. Can you show me how i can do this??
-
- keep in mind the responce to the alert is assync ! You may not find the situation anymore.
- Start traces 1204 and 3605 so you get the deadlock info in the sqlserver errorlog. ( dbcc traceon(1204, 3605, -1) )
- or even better add these to the startup parameters of you sqlserver instance. -T1204 and -T3605
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply