sql server
how to handled deadlock in sql server? any sql example is great
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You will what?
With SSMS
1. execute sp_who2
2. BlkBy column will show the bloker. Deadlock = two SPIDs block each other.
3. Choose the SPID of the victim and: KILL SPID
1. execute sp_who2
2. BlkBy column will show the bloker. Deadlock = two SPIDs block each other.
3. Choose the SPID of the victim and: KILL SPID
Deadlocks are severe problem causing instance since all the processes or the transactions can be troubled, if it occurs..for more read this article https://atdhebuja.wordpress.com/2015/08/25/difference-between-deadlock-and-blocking-in-sql-server/
ASKER