Microsoft KB Archive/271669

= INF: Distributed Queries are not Run as Parallel Query Steps =

Article ID: 271669

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q271669



SUMMARY
Starting with SQL Server 7.0, the SQL Server engine introduces the ability to run a given query with multiple threads. This is often termed as running a command in parallel or &quot;across two or more CPUs.&quot;

Starting with SQL Server 7.0 the SQL Server engine also introduces the ability to query remote data sources by using the OLE-DB interface.

For additional information, refer to the &quot;Linked Servers&quot; topic in SQL Server Books Online.

Due to limitations in certain OLE-DB providers the Linked Query steps are serialized.



MORE INFORMATION
There are operators, such as unions, that may lend themselves to parallel execution. Limitations of certain OLE-DB providers, collation sequences, the ability to gather detailed statistical information and other factors currently limit SQL Server to serialized operations.

Future versions of SQL Server may extend the capabilities where appropriate.

Keywords: kbinfo KB271669

-

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

© Microsoft Corporation. All rights reserved.