bslchennai (6/16/2013)
Hi,I am also facing same problem and in my table i have one clustered and two non-clustered index's, two types of triggers INSERT/UPDATE and i don't have foreign keys in the table, but still insert is taking time and due to this i am getting deadlock also.
In this scenario, I'd be suspicious of the triggers causing the slowdown. Are they complicated, and do they perform lots of inserts/updates themselves? I tend to use more Merge and Output statements rather than triggers now.