网友您好, 请在下方输入框内输入要搜索的题目:
YouadministeraSQLServer2008infrastructure.Aninstancerunsonacomputerthathaseightquad-coreprocessorsand128-GBRAM.Fourdifferent applicationsusetheinstance.TheinstanceexperiencesalownumberofCXPACKETwaits.Theinstancealsoexperiencesalargenumberoflazywriterwaits.Youneedtooptimizetheperformanceoftheinstance.Whatshouldyoudo?()
A.ConfiguretheResourceGovernor.
B.ConfiguretheWindowsSystemResourceManager.
C.Configuresoftwarenon-uniformmemoryaccess(soft-NUMA).
D.Configureanincreaseinthemaximumdegreeofparallelismoption.
参考答案