User profile for ginacresse – Support

Activity overview Badges (0) Posts (4) Comments (2)

Comments

Hi Priya, When I run the sql from the post you directed me to: SELECT object_name(partitions.object_id) AS [Table], indexes.name AS [Index] FROM sys.partitions AS partitions INNER JOIN sys.indexes AS indexes ON partitions.object_id = indexes.object_id WHERE hobt_id = 72057595237695488 I get the following results: Table Index InventoryTran cidx_InventoryTran InventoryTran PK_InventoryTran InventoryTran idx_InventoryTran InventoryTran idx_InventoryTran1 InventoryTran idx_InventoryTran2 InventoryTran idx_InventoryTran3 InventoryTran idx_TranDate InventoryTran idx_InventoryTran4 InventoryTran idx_InventoryTran5 InventoryTran idx_InventoryTran6 InventoryTran idx_InventoryTran7 InventoryTran idx_InventoryTran8 InventoryTran idx_InventoryTran9 When I run the same code with the victim hbid_id: SELECT object_name(partitions.object_id) AS [Table], indexes.name AS [Index] FROM sys.partitions AS partitions INNER JOIN sys.indexes AS indexes ON partitions.object_id = indexes.object_id WHERE hobt_id = 72057595237957632 I get identical results: Table Index InventoryTran cidx_InventoryTran InventoryTran PK_InventoryTran InventoryTran idx_InventoryTran InventoryTran idx_InventoryTran1 InventoryTran idx_InventoryTran2 InventoryTran idx_InventoryTran3 InventoryTran idx_TranDate InventoryTran idx_InventoryTran4 InventoryTran idx_InventoryTran5 InventoryTran idx_InventoryTran6 InventoryTran idx_InventoryTran7 InventoryTran idx_InventoryTran8 InventoryTran idx_InventoryTran9 I'm not sure how this helps me. Am I missing something? / comments

Hi Priya, When I run the sql from the post you directed me to: SELECT object_name(partitions.object_id) AS [Table], indexes.name AS [Index] FROM s...

0 votes

Thank you, Priya. I had looked at that post before, but it seems to be returning information about an index(s). My specific object is a stored procedure (I can tell because of the "DELETE Line #: 469". Why does the Victim object id refer to the correct stored procedure, but the victor object id does not? I have already resolved this particular deadlock on my own, so if you don't have an answer, that is okay. I was just curious. / comments

Thank you, Priya. I had looked at that post before, but it seems to be returning information about an index(s). My specific object is a stored procedure (I can tell because of the "DELETE Line #:...

0 votes

Total activity: 8
Last activity: February 05, 2025 14:03
Member since: February 04, 2025 15:42

Following: 0 users
Followed by: 0 users
Votes: 0
Subscriptions: 2