?????????? ??????????????С????????????????

    1.????С?????8KB??????λ????棬??Щ??汻??????檔(?5?е?SinglePage Allocator)

    2.???????8KB??????λ????棬??Щ?????Multi-Page????MemToLeave??(?5?е?MultiPage Allocator)

 

    ?????????MemToLeave???????MemToLeave???????????SQL Server?????????汻???????????????????Щ?????????????SQL CLR??linked server??backup buffer???????32λSQL Server????????????????????????????????VAS?????????MultiPage Allocator?????屣?????????????1??????

    ??????=((CPU??????-4)+256)*0.5MB+256MB???????384MB?????

Memory Clerk

    ????????????Memory Clerk??Memory Clerk?????????棬?????Allocate??????????з???????????????????????6???.

    ?6.????Memory Clerk???????з???

    ??????4?????????Memory Clerk???????????????????????????????棨Buffer Pool)

 Buffer Pool

    ????????Buffer Pool???????????????????檔

    ??Windows??????????????????????(Virtual Address Space  VAS)??32λ????2??32?η??????4G????4G??Windows?????????????????Windows????????????????ó?????á???????沢??????????????棬??????????????????????????治?????????????????????????????ж???????????????????棬????????????????????棬??????飬?????????д????????:??????????????????

    ???Buffer Pool?????????????????????δ???????????????????????

    ???Buffer Pool???????2???????С????????????????????С???????ζ??SQL Server????????????????棬????SQL Server Buffer Pool?????????????????????????????????

    ??DBCC MEMORYSTATUS ?????????????????????Buffer Pool??????????7?????

    ?7.Buffer Pool????????

    ??SQL Server?????????Buffer Pool???????VAS?????????????????:????????????????SQL Server??32λ????64λ?????????32λ??4G???????????Windows????MemToLeave????????????????SQL Server????????????棬????????????????????8?????

    ?8.??Buffer Pool????????????

    Buffer Pool??????????????????????Buffer Pool????????Buffer Pool??????????棬???Windows??SQL Server?????????Buffer Pool???п????????棬????Buffer Pool???????治??????

    ?????????????????Buffer Pool???????????SQL Server OS????С????μ?????8192??????SQL Server?????????????”Buffer Pool”???????????????8k???λ?裬???????????????????????????????????????????Buffer Pool?????????????Ц???????????????Buffer Pool ??????κ?SQL Server??page allocator??????????virtual??AWE SQLOS's?????