Returns information about the current resource pool state
SELECT pool_id, [Name], statistics_start_time, min_memory_percent, max_memory_percent, max_memory_kb/1024 AS [max_memory_mb], used_memory_kb/1024 AS [used_memory_mb], target_memory_kb/1024 AS [target_memory_mb], min_iops_per_volume, max_iops_per_volume FROM sys.dm_resource_governor_resource_pools WITH (NOLOCK) OPTION (RECOMPILE);