Home Forums SQL Server 2008 SQL Server 2008 - General Deadlock on update command RE: Deadlock on update command
bugg
SSCertifiable
Points: 7567
More actions
March 19, 2013 at 9:13 am
#1598490
ChrisM@Work (3/19/2013)DDL for the table and all indexes, and the actual plans for both queries, would help diagnosis.An index on sessionid including status and rsn may solve the problem.
ChrisM@Work (3/19/2013)
An index on sessionid including status and rsn may solve the problem.
Will grab this info