MemToLeave
Memory To Leave (蟆 覃覈襴豁?) 曙企 螻, 2000蟾讌 譯朱 .
覘 蟆覃,

SQL 蟲覃伎 覃覈襴 , 螳 覃覈襴襯 覿 Buffer Pool襦 渚讌 螻, るジ 豌襴襯 256MB(default)襯 觜手,
Threads襯 蟯襴 覃覈襴 (512KB * Max Thread) 觜殊 32bit default朱, 256+128= 384MB 襷 蟆螻 BPool 渚.
(thread蟯襴 32bit 0.5M, 64bit 2MB襦 蠍一牛)

蟆讌 伎 谿蟶手鍵 り 讌襷 れ襦 覲企 襷れ 譴伎,
BPool 一危一 碁煙り 豪螻
MemToLeave
8KB伎 一危一 朱 企殊伎誤 郁屋 覯朱ゼ 蠍一 麹.
(client 郁屋 覯朱, 蠍磯蓋 ろ語 覯 蠍一 磯殊 8KB覲企 朱 BPool, 豺覲企 覃 MemToLeave 3螳襯 麹. 2, 豢1)
COM蟯 ル 願崖
Linked Server 蟯 レ 願崖 .


2005危 企 谿蟶手鍵る 企語襯 狩ろ讌,
Multi Page Allocator 企 豢.
Single Page Allocator螳 BPool襦, Multi Page Allocator襯 MemToLeave襦 危危覃 覓企Μ

--れ狩

http://blog.naver.com/webman21/10050287502
;With VASummary(Size,Reserved,Free) AS 
(SELECT 
    Size = VaDump.Size, 
    Reserved =  SUM(CASE(CONVERT(INT, VaDump.Base)^0) 
    WHEN 0 THEN 0 ELSE 1 END), 
    Free = SUM(CASE(CONVERT(INT, VaDump.Base)^0) 
    WHEN 0 THEN 1 ELSE 0 END) 
FROM 
( 
    SELECT  CONVERT(VARBINARY, SUM(region_size_in_bytes)) 
    AS Size, region_allocation_base_address AS Base 
    FROM sys.dm_os_virtual_address_dump  
    WHERE region_allocation_base_address <> 0x0 
    GROUP BY region_allocation_base_address  
 UNION   
    SELECT CONVERT(VARBINARY, region_size_in_bytes), region_allocation_base_address 
    FROM sys.dm_os_virtual_address_dump 
    WHERE region_allocation_base_address  = 0x0 
) 
AS VaDump 
GROUP BY Size)
SELECT SUM(CONVERT(BIGINT,Size)*Free)/1024/1024/1024 AS [豐MemToLeave, GB] ,CAST(MAX(Size) AS BIGINT)/1024/1024/1024 AS [MemToLeave, GB]  
FROM VASummary  
WHERE Free <> 0

谿瑚襭 #