YouadministeraSQLServer2008infrastructure.Aninstancerunsonacomputerthathaseightquad-coreprocessorsand128-GBRAM.Fourdifferent applicationsusetheinstance.TheinstanceexperiencesalownumberofCXPACKETwaits.Theinstancealsoexperiencesalargenumberoflazywriterwaits
题目
YouadministeraSQLServer2008infrastructure.Aninstancerunsonacomputerthathaseightquad-coreprocessorsand128-GBRAM.Fourdifferent applicationsusetheinstance.TheinstanceexperiencesalownumberofCXPACKETwaits.Theinstancealsoexperiencesalargenumberoflazywriterwaits.Youneedtooptimizetheperformanceoftheinstance.Whatshouldyoudo?（）
A.ConfiguretheResourceGovernor.
B.ConfiguretheWindowsSystemResourceManager.
C.Configuresoftwarenon-uniformmemoryaccess(soft-NUMA).
D.Configureanincreaseinthemaximumdegreeofparallelismoption.