????SQL??32λ??64λ???е????????
???????????? ???????[ 2013/4/19 11:32:01 ] ????????
????????
???????????32λ??64λ???е???????????SQLServer 2005/2008?У?DBA?????????????AWE????????檔???????SQLServer2012??????????????????????????????????????32λ???????????????????????????к????棬?????????64λ??????????????????????????
???????2012??????????AWE????????????32λ????????AWE(Address WindowingExtensions)????ò??????????????????檔????????????????Maximum Server memory???????????SQLServer????????Maximum Server memory??????Maximum Server memory????????????????????????????????????????SQLServer???????????п?????棬??????256MB??
?????????????
????????????Maximum Server memory??Minimum Server memory??????????????sys.configurations???в????????????????????????????????
???????裺
????1???????????????SQLServer??С??棺
EXEC sp_configure 'min server memory (MB)'?? 1024
GO
RECONFIGURE WITH OVERRIDE ;
GO
????2?????????????????棺
EXEC sp_configure 'max server memory (MB)'?? 3000
GO
RECONFIGURE WITH OVERRIDE ;
GO
??????????
????????1????С????SQLServer???????0??????????С?С??????max server memory?????
????????2????SQLServer????????棬?????2TB??????????????64M??
???????е????????????SQLServer??buffer pool?С?????????32λ???????SQLServer??????ó???3G????檔???????ж????????????????????????????AWE??PAE??
??????????е????????????????SQLServer????????????漴???????????ж???????????С????????????????????棬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