Bora.Choi

-- 리소스 관리자 category view
-- veiw any definition, 변경시 control server 
select * from sys.resource_governor_configuration  with (nolock)
SELECT 
 classifier_function_id
 ,object_schema_name(classifier_function_id) AS 'Classifier UDF schema' 
 ,object_name(classifier_function_id) AS 'Classifier UDF name'
 ,is_enabled
FROM sys.resource_governor_configuration
GO
-- resource pool info
select * from sys.resource_governor_resource_pools  with (nolock)
select * from sys.resource_governor_workload_groups with (nolock)
 
 
-- 리소스 관리자를 변경했을 때 재구성 문 필요 여부
select * from sys.dm_resource_governor_configuration   with (nolock)
 
select * from sys.dm_resource_governor_workload_groups  with (nolock)
select * from sys.dm_resource_governor_resource_pools as with (nolock)

select p.pool_id, g.group_id, p.name, p.statistics_start_time
 , p.total_cpu_usage_ms,p.used_memgrant_kb, p.active_memgrant_kb
 , p.min_cpu_percent, p.max_cpu_percent, p.min_memory_percent, p.max_memory_percent
 , g.name, g.importance,g.total_cpu_usage_ms, g.max_dop
 , g.total_query_optimization_count, g.active_parallel_thread_count
from sys.dm_resource_governor_resource_pools as p with (nolock)
 join sys.dm_resource_governor_workload_groups as g with (nolock)
  on p.pool_id = g.pool_id
order by p.pool_id