Microsoft KB Archive/329906

= BUG: Parallel Query Takes Longer to Execute on Multiple Processors Than on Single Processor =

Article ID: 329906

Article Last Modified on 5/22/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 7.0 Service Pack 3
 * Microsoft SQL Server 7.0 Service Pack 4

-



This article was previously published under Q329906



BUG #: 102895 (sqlbug_70)



SYMPTOMS
A parallel query may take longer to execute on a computer with multiple processors than on a computer with a single processor.



WORKAROUND
To work around this problem, add (MAXDOP 1) as a query hint. The MAXDOP 1 hint overrides the max degree of parallelism configuration option of the sp_configure stored procedure for the query, and it suppresses parallel plan generation. For more information about using the MAXDOP 1 query hint, see the Transact-SQL &quot;SELECT&quot; statement topic in SQL Server Books Online:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sa-ses_9sfo.asp



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

