_覓 | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁 |
FrontPage › SQLServerMemoryConfiguration/DeterminingMemToLeaveSettings
|
|
[edit]
1 谿瑚 #WITH VAS_Summary AS ( SELECT Size = VAS_Dump.Size, Reserved = SUM( CASE (CONVERT(INT, VAS_Dump.Base) ^ 0) WHEN 0 THEN 0 ELSE 1 END), Free = SUM( CASE (CONVERT(INT, VAS_Dump.Base) ^ 0) WHEN 0 THEN 1 ELSE 0 END) FROM ( SELECT CONVERT(VARBINARY, SUM(region_size_in_bytes)) [Size], region_allocation_base_address [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) [Size], region_allocation_base_address [Base] FROM sys.dm_os_virtual_address_dump WHERE region_allocation_base_address = 0x0 ) AS VAS_Dump GROUP BY Size ) SELECT SUM(CONVERT(BIGINT, Size) * Free) / 1024 AS [Total avail mem, KB], CAST(MAX(Size) AS BIGINT) / 1024 AS [Max free size, KB] FROM VAS_Summary WHERE Free <> 0
鏤
|
螳 朱 蟲 豌 覺 讌朱 覦 螳襴襯 讌 . 覺 朱 覲旧蟒企 覯蟒 覿讌 . 襴 覿 ル瑚 企蟆 るジ 蟒覲企 蟆 朱 讌 . 蠏語 覓給牛 譴觜覃 願概 螻 訖企. 蠏碁り 襷る語襴 蠏語螻 讌 螳 蠍 谿襦螳 讌蠍 蟲 る 譴觜伎 蠏 リ鍵 襯 襷蟷 觸企 蟆企. (觜) |