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
Discussion on:
Message 4 of 4









































