网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）

YouadministeraSQLServer2008instance.Theinstancerunsonacomputerthathasthefollowingfeatures:A64-GBRAM Fourquad-coreprocessors Severalindependentphysicalraidvolumes Youplantoimplementatransactionaldatabaseontheinstance.ThedatabaseisexpectedtohaveahighvolumeofINSERT,UPDATE,andDELETEactivities.Theactivitiesincludecreationofnewtables.Youneedtooptimizetheperformanceofthedatabasebymaximizingdiskbandwidthandreducingthecontentioninthestorageallocationstructures.Whatshouldyoudo?（）

A.Createmultipledatafilesforthedatabase.

B.Placedatabaseandlogfilesonthesamevolume.

C.Configuretheaffinitymaskoptionappropriately.

D.ConfiguretheaffinityI/Omaskoptionappropriately.

参考答案

更多 “ YouadministeraSQLServer2008instance.Theinstancerunsonacomputerthathasthefollowingfeatures:A64-GBRAM Fourquad-coreprocessors Severalindependentphysicalraidvolumes Youplantoimplementatransactionaldatabaseontheinstance.ThedatabaseisexpectedtohaveahighvolumeofINSERT,UPDATE,andDELETEactivities.Theactivitiesincludecreationofnewtables.Youneedtooptimizetheperformanceofthedatabasebymaximizingdiskbandwidthandreducingthecontentioninthestorageallocationstructures.Whatshouldyoudo?（）A.Createmultipledatafilesforthedatabase.B.Placedatabaseandlogfilesonthesamevolume.C.Configuretheaffinitymaskoptionappropriately.D.ConfiguretheaffinityI/Omaskoptionappropriately. ” 相关考题
热门标签
最新试卷