Alert keeps reappearing

nuberfin

I have a deadlock alert that I keep clearing only to have it re-appear over and over. It occurred on 7/31/2009 and continues to re-appear. There have been no instances of the lock since then, yet it keeps throwing the alert every few minutes as if it's a new one each time. The email portion of the alert follows. Any thoughts????


SQL deadlock

Server : NATSYSPDB3
Alert Level : High

Occurred at : 7/30/2009 1:03:25 PM

Description : Deadlock detected on NATSYSPDB3
More details for Server: NATSYSPDB3 - [url=sqlresponse://natsyswit3.nsi.int:7398/22/8cbdf2d42449580]sqlresponse://natsyswit3.nsi.int:7398/2 ... 2d42449580[/url]

Matthew Flatt

Hi nuberfin,

Could you take a look at the SQL Error log and see if there seems to be any problems with the time? Could you also try cycling the error log and see if that stops it?

You can use this command:

sp_cycle_errorlog

I hope this helps,

nuberfin

No issues with the time that I can see. I have a job that recycles the error log every week that ran on 8/2 (after the notification), but I'll try another recycle and see if it solves the issue.

Thanks!

Eddie D

Hi

Are you still having problems with this Alert that keeps repeating?

Or did recycling the error log resolve the problem?

Many Thanks
Eddie

nuberfin

So far so good after recycling the error log again. Thanks for the follow up!