Locking with ObjectID 0

Bih Luh Hew 1 Reputation point


Recently I keep getting blocking from an application code that uses MSDTC with Serializable isolation level. The head blocked was waiting for a an Object where ID is 0, when too many of them, it caused deadlock.

How can we know what was the object since the objectID is 0 ?

<process status="running" waitresource="OBJECT: 10:0:5 " spid="98" sbid="2" ecid="0" priority="0" trancount="1" lastbatchstarted="2021-06-18T13:48:43.553" lastbatchcompleted="2021-06-18T13:48:43.550" lastattention="1900-01-01T00:00:00.550" clientapp="EntityFrameworkMUE" hostname="XXXXXXX" hostpid="15216" loginname="XXXXXXX" isolationlevel="serializable (4)" xactid="13275674392" currentdb="10" lockTimeout="4294967295" clientoption1="671088672" clientoption2="128056">

Bih Luh

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,691 questions
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,552 questions
{count} votes

2 answers

Sort by: Most helpful
  1. CathyJi-MSFT 21,086 Reputation points Microsoft Vendor

    Hi @Bih Luh Hew ,

    > How can we know what was the object since the objectID is 0 ?

    If you see the ObjectId is 0, that means there was no metadata found. This could be because:

    •The table that the page was part of has been deleted since the page corruption was logged
    •The system catalogs are corrupt in some way
    •The page is corrupt and so incorrect values were used to look up the metadata

    Please refer to the blog Finding a table name from a page ID.

    We can using below T-SQL to check object name.

    USE DBname;  
    SELECT OBJECT_NAME (objectID);  

    Please refer to MS document OBJECT_NAME (Transact-SQL).

    If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. Bih Luh Hew 1 Reputation point

    @CathyJi-MSFT ,

    We have DBCC every week but there wasn't any corruption reported.

    Bih Luh