Resource Governor Category View
2012. 8. 13. 18:28 in Resource Governor

SQL Server 2008 이상.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 | -- 리소스 관리자 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 |
'Resource Governor' 카테고리의 다른 글
Resource Governor (0) | 2011.11.28 |
---|