????????

????Sp_configure ???????????????SQLServer??????????????????????????SQLServer ManagementStudio????λ?????????

?????????????

????????SQLServer????????????????????????в????????

SELECT  *
FROM    sys.configurations
ORDER BY name

???????????????????

???????裺

????1??????????????????????????????

sp_configure
GO

????2?????????п???????????????????????

sp_configure 'show advanced options'?? 1 ;
GO
RECONFIGURE
GO

????3??????????в??????????????????????????

sp_configure
GO

????4?????????????????

sp_configure 'recovery interval'?? 5 ;
RECONFIGURE WITH OVERRIDE
GO

????5????????????????????????????С??

sp_configure 'index create memory (KB)'?? 1024 ;
RECONFIGURE WITH OVERRIDE
GO

??????????

????????????????????????????RECONFIGURE WITHOVERRIDE ???????????SQLServer??????????????????????????????sp_configure??????????SQLServer??

?????????1?У?sp_configure?洢?????????????????????????????????????????????????????????????ò???2?е??????ShowAdvanced Option?????0???1??

????????3?У?????????и?????????????????2???????????????

?????????4?У?????????????5???????ζ???5??????????Ρ?SQLServer???????checkpoint???????????д????????????С?

????????崠?У?????????????????????棬???????????????????????????????????????????????????SQLServer???????檔?????SQLServer???????????????????????????????????

????????????

??????????????????????????????????????????????????????????????