get_resource_pool_pct_needed.sql

USE master
GO
DECLARE @memoryNeeded INT = 16
SELECT percentNeeded = @memoryNeeded / 
		ROUND(((committed_target_kb/1024)/1024) * 
		(CASE  
			WHEN (committed_target_kb/1024)/1024 <= 8 THEN 0.7
			WHEN (committed_target_kb/1024)/1024 <= 16 THEN 0.75
			WHEN (committed_target_kb/1024)/1024 <= 32 THEN 0.8
			WHEN (committed_target_kb/1024)/1024 <= 96 THEN 0.85
			ELSE 0.9
		END), 0)
FROM sys.dm_os_sys_info