YouadministeraSQLServer2008instance.Theinstanceislocatedonafour-processor,quad-coreserver.TheserverfrequentlyexperiencesCPUpressure.Theinstancecontainsaverylargemission-criticaldatabasethatisusedcontinuously.Youneedtoensurethatonlineindexrebuildsdonotcons
题目
YouadministeraSQLServer2008instance.Theinstanceislocatedonafour-processor,quad-coreserver.TheserverfrequentlyexperiencesCPUpressure.Theinstancecontainsaverylargemission-criticaldatabasethatisusedcontinuously.YouneedtoensurethatonlineindexrebuildsdonotconsumeallavailableCPUcycles.Whichconfigurationoptionshouldyouuse?（）
A.affinitymask
B.affinityI/Omask
C.maxdegreeofparallelism
D.optimizeforadhocworkloads