SELECT OBJECT_NAME(i.object_id) ,
i.name
FROM sys.partitions AS p
INNER JOIN sys.indexes AS i ON i.object_id = p.object_id
AND i.index_id = p.index_id
WHERE p.partition_id = 72057594382909440把你死锁图中的hobtid替换一下,看看两个对象是什么东西
i.name
FROM sys.partitions AS p
INNER JOIN sys.indexes AS i ON i.object_id = p.object_id
AND i.index_id = p.index_id
WHERE p.partition_id = 72057594382909440把你死锁图中的hobtid替换一下,看看两个对象是什么东西
from 表 with(nolock)