SQL SERVER MAXDOP Settings to Limit Query to Run on Specific CPU
Posted
on Dot net Slackers
See other posts from Dot net Slackers
Published on Mon, 15 Mar 2010 00:00:00 GMT
Indexed on
2010/03/15
2:40 UTC
Read the original article
Hit count: 335
Filed under:
This is very simple and known tip. Query Hint MAXDOP – Maximum Degree Of Parallelism can be set to restrict query to run on a certain CPU. Please note that this query cannot restrict or dictate which CPU to be used, but for sure, it restricts the usage of number of CPUs in a single [...]...
Did you know that DotNetSlackers also publishes .net articles written by top known .net Authors? We already have over 80 articles in several categories including Silverlight. Take a look: here.
© Dot net Slackers or respective owner
