????SQL?????SQLServer?????????
???????????? ???????[ 2013/4/23 10:28:10 ] ????????
????????
????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???????????????????????????????????
????????????
??????????????????????????????????????????????????????????????
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11