Posted by Erland Sommarskog on 12/15/06 16:22

Dan Guzman (guzmanda@nospam-online.sbcglobal.net) writes:
> To add on to Erland's response, excessive parallelism can be a symptom
> that query and index tuning is needed. The optimizer will sometimes
> throw processors at the problem to compensate.

Yeah, but in those cases the query usually don't complete in three seconds
if constraint to one CPU!


--
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

• Next in forum: Re: Execute proceduers from another Proceduer with error handling
• Prev in forum: Re: Performance Difference between SQL Server 2005 Standard Edition and Enterprise Edition
• Thread view: Re: max degree parallelism

[Reply to this message]