Post reply

LOCK MONITOR

  • April 15, 2004 at 3:10 pm

    #85175

    The following messages have started popping up in our SQL Server log on one of our production servers. We're getting at least 2 - 3 per minute. We don't know why they started coming out ( I suspect someone was monkeying around on the server) and we don't know how to turn them off and it's become quite an annoyance. We thought someone had tuned on a trace but when we ran

    DBCC TRACESTATUS (-1) in QA we get a reply that says there are no TRACE options enabled.

    Starting deadlock search 1309271

    Target Resource Owner:

    ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:0 Ec0x31DEB568) Value:0x4eee55a0

    Node:1 ResType:LockOwner Stype:'OR' Mode: S SPID:53 ECID:0 Ec0x31DEB568) Value:0x4eee55a0

    End deadlock search 1309271 ... a deadlock was not found.

    Thanks in advance.

  • April 16, 2004 at 12:54 pm

    #503190

    Did you try dbcc traceoff (3605)

  • April 16, 2004 at 1:22 pm

    #503197

    Even though I got a 'Trace Option(s) not enabled for this connection' message when I ran a DBCC TRACESTATUS

    (-1) I stopped the messages by entering a DBCC TRACEOFF (1205). Thanks.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply