How can we help you today? How can we help you today?

Alert keeps reappearing

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]
nuberfin
0

Comments

4 comments

Sort by
  • 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,
    Matthew Flatt
    0
  • 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!
    nuberfin
    0
  • 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
    Eddie D
    0
  • nuberfin
    So far so good after recycling the error log again. Thanks for the follow up!
    nuberfin
    0

Add comment

Please sign in to leave a comment.