Microsoft KB Archive/282175

= FIX: Parallel Query on Four CPUs Using NLS Is Slower Than Two CPUs =

Article ID: 282175

Article Last Modified on 3/14/2006

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q282175



BUG #: 58078 (SQLBUG_70)



SYMPTOMS
Parallel query performance on a computer with four CPUs is poorer than on a computer with two CPUs if you are using the National Language Support (NLS) sort order with the double-byte character set (DBCS).

You may encounter this problem if all of the following conditions are true:
 * You are using the NLS sort order with DBCS.
 * The query processor chooses the Parallelism physical operator.
 * The table has a column of character data type that is used by the Parallelism physical operator.



RESOLUTION


WORKAROUND
To work around this problem, do one of the following:
 * Use the binary sort order.

-or-
 * Restrict the number of threads in parallel plan execution, by using the &quot;max degree of parallelism&quot; option or MAXDOP query hint.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

274799 INF: How to Obtain Service Pack 3 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0

For more information, contact your primary support provider.

Additional query words: NLS Parallel Parallelism MAXDOP cpu processor processors proc procs

Keywords: kbbug kbfix KB282175

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.