How can we handle DEADLOCK

[jason_clark]

you need to enable TF 1222 and/1204 to capture deadlock details. Read here: https://www.simple-talk.com/sql/database-administration/handling-deadlocks-in-sql-server/