Contents

1 참고소스

2 참고자료

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

• MemToLeave 영역에 대한 메모
  
• http://www.sqlservercentral.com/articles/Administration/67192/