Deadlock alert firing every 5 mins but nothing in the log

[SQLWilts]

I have set up an alert that fires every 5 mins and sends me an email if deadlocks exceed 4 per second. No probs, one would think. It is currently firing EVERY 5 mins but I cannot see anything written to the log. I have set DBCC TRACEON 3604 and 1204 but still noting in the log - just this constant emailing.
Any pointers as to where I could look people? I want to see what is causing these deadlocks and eliminate (or at least reduce) the numbers - unless of course the deadlock is momentary............ but should it still be written to the log?

 

[SQLWilts]

Small update - after adding the 2605 trace I am getting multiple entries in the log telling me lots of info ending "ending search 3125 (incrementing number) a deadlock was not found"
If there are no deadlocks, why oh why is the alert firing?

 

[Crowley16]

perhaps the alert has been set to look at all events instead of just deadlocks...?

--------------------
Procrastinate Now!

 

[SQLWilts]

I thought that, but looking at it, it is firing on deadlocks/sec and counter _Total.

It was fine for ages, (ever??) and suddenly fires every time. Watching perfmon, there are 0 locks (looking at the same counter).

I'm stuck - am trempted to turn it off and schedule a SQL restatr at the next maintenance window (3 weeks from now)

 

[Crowley16]

try removing the alert, and creating a new one...

--------------------
Procrastinate Now!