May 23, 2007 08:23 PM
Help with Examining Parallel-Query Plans
Rating:

(0)
SQL Server Magazine
InstantDoc ID #95497
If you don't actually have a multiprocessor machine on which you can test the
code in the main article, that doesn't mean that you'll never see a DegreeOfParallelism
greater than one. You can simulate multiple processors by using a special flag
when you start SQL Server. To do so, in SQL Server Configuration Manager, expand
the node for SQL Server 2005 Services. Right-click your SQL Server service and
choose Properties. On the Advanced tab, expand the Startup Parameters value, and
add -Pn<...
...This article is for paid Professional Members only.
Already a Professional Member? Please log in now: