Risposta:
select request_session_id, count(*) AS Total from sys.dm_tran_locks group by request_session_id
Dal BOL: “sys.dm_tran_locks returns information about currently active lock manager resources. Each row represents a currently active request to the lock manager for a lock that has been granted or is waiting to be granted”