troubleshooting Question

Is this a deadlock ?

Avatar of JaffaKREE
JaffaKREEFlag for United States of America asked on
Microsoft SQL Server
10 Comments1 Solution883 ViewsLast Modified:
Cycle:       ResType:LockOwner Stype:'OR' Mode: U SPID:223 ECID:0 Ec:(0x7BE37540) Value:0x5a2fbd80 Cost:(0/0)
Node:2       ResType:LockOwner Stype:'OR' Mode: IX SPID:238 ECID:0 Ec:(0x42E21548) Value:0x328a6600 Cost:(0/0)
Node:1       ResType:LockOwner Stype:'OR' Mode: U SPID:223 ECID:0 Ec:(0x7BE37540) Value:0x5a2fbd80 Cost:(0/0)
Deadlock cycle was encountered .... verifying cycle
ResType:LockOwner Stype:'OR' Mode: U SPID:223 ECID:0 Ec:(0x7BE37540) Value:0x5a2fbd80
Target Resource Owner:

What exactly is this log information telling me ?  It's from activation of trace flag 1205.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros