Sample Header Ad - 728x90

What is the object involved in an Object Lock in SQL Server Profiler's Deadlock graph?

1 vote
0 answers
330 views
In searching documentation online, I have found that there can be row, page, or table locks. However, I ran a SQL Server Profiler trace and noticed both a Page Lock and an Object lock. I can easily discern the table involved in the Page lock from the "Object name". However, the Object lock does not give any further details. How can I know what the non-victim process locked?c enter image description here
Asked by Paradox (155 rep)
Feb 13, 2023, 09:07 PM