• I did the same. I wrote sql sp and added it as SQL JOB to log into table all lockings/blockings holding more than some criteria(logging blocking/locked required resource,type of lock,cmds,duration,application,user,etc.). If it continues more than normal time script sent error on email. This helped a lot in troubleshooting applications, especially new ones. You could kill process and then analyze the log on problem cause.