|
Posted by Erland Sommarskog on 10/14/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
Navigation:
[Reply to this message]
|