Incase you are expecting a DEADLOCK in an environment where your process/job is going to run executing DML statements and you are fully aware that the process take priority over all other processes/jobs, you can set its priority to HIGH.
This specifies the rank/priority of your process higher than any other process when deadlock is detected.
Deadlock priority is set before the TRY block in the procedure.
Hope this helps....
No comments:
Post a Comment