Database Reference
In-Depth Information
SET STATISTICS IO OFF
GO
SET SHOWPLAN_ALL OFF
GO
4.
As we are gathering query execution statistics along with a query execution plan on
the preceding query, the results are displayed as follows:
5.
Again, let us execute the same query by using the MAXDOP hint:
--To avoid PARALLELISM Physical Operation and run on a SINGLE core
Use Adventureworks2008R2
GO
SELECT * FROM Production.TransactionHistoryArchive ORDER BY
ProductID,Quantity
OPTION (MAXDOP 1)
6.
The query statistics and execution plan information are displayed as follows:
7.
In addition to the MAXDOP hint, the SQL Server Resource Governor can be used
to limit the amount of CPU resources for a workload request and the corresponding
requests can be managed differently.
This completes the steps that are required in implementing parallel query processing methods.
 
Search WWH ::




Custom Search