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
|||yes. Nothing wrong with sql agent. as such i get other alerts but not this one.|||Is the occurrence count still zero ?Is the SQL Agent definitely running ?
If so, "Test" that that the SQL Agent can create a mail session. Right click SQL Server Agent, choose Properties, click the test button.
Under the Response tab try reducing the "delay between responses". I recall reading somewhere that if at the time SQL samples the counters there may well not be a deadlock. i.e. the delay between responses is sufficiently high for the condition to disappear before SQL samples the data.
No comments:
Post a Comment