????????

???????????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????????棬???????????????治????????ú?????????棬??????????????