DeadLock
-
This is a question related to OLTP System. If some is trying to update 15-20 rows in a table and is been deadlocked by another process. How can an administrator gives the person a priority so that his transaction gets completed and what are the ways for given any important transaction and priority or any particuler users transaction more priority
Thanks
-
You can use SET DEADLOCK_PRIORITY LOW to identify a transaction that should become the deadlock victim if necessary. If you have an existing deadlock situation, use sp_lock and then sp_who to figure out which SPID you must sacrifice to break the deadlock.
-
Can tell me more in detail like i have 2 spid 376, 433 are found victims and i have to give priority to 433 to complete its transactions. How can i do that.
Cheers:
-
kill 376
-- Amit
-
if you can not set deadlock priority it in the SQL Code fired by that session. then simply kill the other process causing deadlock ....
kill 376
-- Amit
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply