_覓 | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁 |
FrontPage › 覲讌蟲 › 螳燕願屋豺 › INSERTEXECUTEStatementsCanExecuteAgainstLinkedServers › 蠍襴麹覃_201703 › 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
鏤
|
讌 願 殊 覓企 る 蟆 朱 る所 蠍一 殊瑚. ルレ れ 豺 る 蟆 覲牛 殊企朱 蟆 螻 磯る 譟郁 殊 譟郁讌 蟆企. 讌 ル 企朱 蟆 讌 襷 螳碁 譬 企朱 覩碁 覦蠖覲伎. (蟾伎) |