YouadministeraSQLServer2008instance.Theinstanceislocatedonafour-processor,quad-coreserver.TheserverfrequentlyexperiencesCPUpressure.Theinstancecontainsaverylargemission-criticaldatabasethatisusedcontinuously.YouneedtoensurethatonlineindexrebuildsdonotconsumeallavailableCPUcycles.Whichconfigurationoptionshouldyouuse?()A.affinitymaskB.affinityI/OmaskC.maxdegreeofparallelismD.optimizeforadhocworkloads

YouadministeraSQLServer2008instance.Theinstanceislocatedonafour-processor,quad-coreserver.TheserverfrequentlyexperiencesCPUpressure.Theinstancecontainsaverylargemission-criticaldatabasethatisusedcontinuously.YouneedtoensurethatonlineindexrebuildsdonotconsumeallavailableCPUcycles.Whichconfigurationoptionshouldyouuse?()

A.affinitymask

B.affinityI/Omask

C.maxdegreeofparallelism

D.optimizeforadhocworkloads


相关考题: