Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Deadlock involving Identity Column RE: Deadlock involving Identity Column
Michael Valentine Jones
SSC Guru
Points: 64818
More actions
September 9, 2013 at 9:35 am
#1648583
I doubt that having a clustered index on the identity column is the cause of the deadlocks.
You need to analyze the deadlock information in detail to determine exactly what resource is being deadlocked.