BUG: Parallel Query Takes Longer to Execute on Multiple Processors Than on Single Processor (329906)
The information in this article applies to:
- Microsoft SQL Server 7.0
- 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) SYMPTOMSA parallel query may take longer to execute on a computer
with multiple processors than on a computer with a single
processor.
WORKAROUNDTo 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 "SELECT" statement topic in SQL Server Books Online: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sa-ses_9sfo.aspSTATUS Microsoft
has confirmed that this is a problem in the Microsoft products that are listed
at the beginning of this article.
REFERENCES For additional information, click the following article number
to view the article in the Microsoft Knowledge Base: 282175
FIX: Parallel Query on Four CPUs Using NLS Is Slower Than Two
CPUs
247500 FIX: Parallel Sort May Be Slower Than Non-Parallel Sort
| Modification Type: | Major | Last Reviewed: | 5/22/2003 |
|---|
| Keywords: | kbPerformance kbbug kbpending KB329906 kbAudDeveloper |
|---|
|