IZ
FROM sys.dm_tran_locks AS tl with (nolock)
left join sys.partitions AS p with (nolock)
ON p.hobt_id = tl.resource_associated_entity_id
left join sys.indexes AS si with (nolock)
ON p.object_id = si.object_id
and p.index_id = si.index_id
join sys.dm_exec_sessions sess with (nolock) on tl.request_session_id=sess.session_idВ смысле , всё ОК там с локами.
