本章要点7.1调整SQLServer配置参数的目的7.2.2什么时候需要调整配置参数7.2.3配置参数的类型静态参数动态参数7.2.4sysconfigures表和syscurconfigs表7.3配置文件7.3.4SQLServer启动时如何指定配置文件7.3.5配置文件的备份文件7.3.9配置文件的样本[ConfigurationOptions][GeneralInformation][Backup/Recovery]recoveryintervalinminutes=DEFAULTprintrecoveryinformation=DEFAULTtaperetentionindays=DEFAULT[CacheManager]numberofoamtrips=DEFAULTnumberofindextrips=DEFAULTprocedurecachepercent=10memoryalignmentboundary=DEFAULT7.4sp_configure命令sp_configure显示所有配置参数的值sp_configure‘parameter’显示缺省、当前、最近修改的值，以及该参数所占内存sp_configure‘parameter’，value设置参数sp_configure‘parameter’，0，default将参数设置为缺省值sp_configure‘groupname’显示一组值sp_configure"configurationfile",0,"sub_command","file_name”带configurationfile参数的sp_configure命令7.4.3使用sp_configure配置或显示SQLServer参数语法:sp_configure[config_name[,config_value]]sp_configure显示配置参数值方法一举例：sp_configureGroup:ConfigurationOptionsGroup:Backup/RecoveryParameterNameDefaultMemoryUsedConfigValueRunValue------------------------------------------------------------------------------------------------allowremoteaccess1011printrecoveryinformation0000recoveryintervalinminutes5055taperetentionindays0000Group:CacheManagerParameterNameDefaultMemoryUsedConfigValueRunValue--------------------------------------------------------------------------------------------memoryalignmentboundary2048020482048numberofindextrips0000numberofoamtrips0000procedurecachepercent20142102020totaldatacachesize054782054782totalmemory7500819204096040960........方法二举例：sp_configurenumberofuserconnectionsParameterNameDefaultMemoryUsedConfigValueRunValue-------------------------------------------------------------------------------------numberofuserconnections2527122525方法三举例：sp_configurephysicalMemoryGroup:PhysicalMemoryParameterNameDefaultMemoryUsedConfigValueRunValue-----------------------------------------------------------------------------------------additionalnetworkmemory0000locksharedmemory0000sharedmemorystartingaddress00