I am trying to understand if the result I am seeing is normal for a long running process or an indication of a problem.
When I run
select * from sys.dm_tran_locks
I am getting over 60k rows showing all from different session ids.
resource_type = PAGE
resource_description = same value
resource_associated_entity_id = same value
request_mode = S
request_status = GRANT
I'm trying to understand if this means that the query currently running needs tuning or if it is normal to see this much rows showing different 'request_session_id' with a shared lock on the same object?