Is there any way to decipher if a lock in a deadlock graph is Table, Page or Row level? I have all the information I need from the graph, including the Isolation Level, (2) but I really want to know this, too.
Thanks to anyone who can help!
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
In the deadlock graph XML you will see something like:
<deadlock-list> <deadlock victim="..."> <process-list> <process id="..." ... waitresource="X:..." ...
X is the interesting bit, possible values you are interested in are:
RIDfor row id (row level locking)
PAGfor page level lock
OBJECT(which may be further qualified
TABindicating a table lock)
There are a few others kinds listed in the documentation also.