Thursday, October 13, 2011

Indexes causes deadlocks in SQL Server



Another common scenario for deadlock
If make a lot of indexes with same set of columns but sequence is different, can cause deadlocks between select/update query.
Solution:
Carefully design indexes for a table, don’t let tuning advisor do it for you.

Reference:




No comments:

Post a Comment