Posted by Erland Sommarskog on 09/29/79 11:34

Mark D Powell (Mark.Powell@eds.com) writes:
> About 1/3 of the data in the table was obsolete so we deleted it. The
> deadlocks were still occurring. I ran maintenance on the database
> during a break period. The update is once again showing as being
> single threaded by the query plan and the deadlocks errors have
> disappeared.

Hm, so maybe locks are acquired in a different order when the plan is
single-threaded.

> We have not applied the index because the customer wants to hold off on
> changing the customized by the providing vendor application until their
> consultant(s) have had time to review the code and come up with a
> comprehensive list of changes.

I still think the index is a good idea. If nothing else, it will take
off load from the machine.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]