??SQL Server???????????
???????????? ???????[ 2013/1/30 10:35:30 ] ????????
?????????? ??????????????С????????????????
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?????
??????
???·???
??????????????????
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