Alert keeps reappearing

nuberfin · August 3, 2009 11:52AM

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 · August 4, 2009 1:43PM

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 · August 5, 2009 9:27AM

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 · August 10, 2009 9:53AM

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 · August 12, 2009 12:15AM

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

Alert keeps reappearing

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk