Sunday, March 25, 2012

Deadlock with Port: 0

I've been diagnosing deadlocks for a last couple weeks at a client site and I understand the KEY: and TAB: locks issues. However, the client recently experienced a series of multi-branch deadlocks for which I can find no information. Attached is the deadlock text from the ERRORLOG. Any help would be much appreciated.

NickHave you tried to capture deadlocks with the profiler ? It is surely clearer than errorlogs.|||Unfortunately I don't have access to the production system this is running on. I have run profiler traces but that still doesn't tell me anything about Port: 0.

No comments:

Post a Comment