Discussion on:

Message 4 of 4
0 Votes
+ -
How to find the first process causing the lock
Is there a way to find the first process starting the lock? I use sys.sysprocesses dmv, that shows blocked spid and I see many times multiple spids causing locking and often struggle to find out the first process, query that started it all.
Thanks
Posted by mgalivi@...
7th Sep