We have DBCC every week but there wasn't any corruption reported.
Regards,
Bih Luh
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi,
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">
<executionStack/>
Regards,
Bih Luh
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;
GO
SELECT OBJECT_NAME (objectID);
GO
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.