I just trying to understands why one of the sessions could place around 700 000 lock ? I found this with a command below.
actually when is sql server placing a lo of locks compare to only 1 lock ? for example if we update one table with 1 millions of rows. Is this produced one or 1millions of locks ?
update tableB set columnB='Testing123"
SELECT request_session_id, COUNT (*) num_locks
GROUP BY request_session_id
ORDER BY count (*) DESC