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:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS