You work as DBA at AIOTestKing.com. You administer a SQL Server 2005 computer named AIOTestKingA. AIOTestKing A has recently been upgraded from two to eight processors. The AIOTestKing A configuration is summarized in the following table.
You need to optimize AIOTestKing A so that longer running queries can run parallel plans.
What should you do?
A.
Change the AWE enabled setting to 0.
B.
Change the max degree of parallelism to 1.
C.
Change the cost threshold for parallelism to 0.
D.
Change the affinity mask to 0.
Explanation:
To carry out multitasking, Microsoft Windows 2000 and Windows Server 2003 sometimes move process threads among different processors. To enable the enable one or more processors, use the affinity mask option.