Monitor Resource Governor
Possibility to monitor Resource Governor Pools:
• Show statistics on pools
• Show workload of groups: cpu, io and memory
-
bryan commented
The metric "Workload Group Statistic metric" is missing from the Analysis tab.
-
Dirk commented
Overview defined resource pools - workload groups - defined RG classifier function
Monitor
- the current runtime data for the resource pools and workload groups
- if resource pool is experiencing a high number of query optimizations or suboptimal plan generations
- users from each workload group that are currently connected, and which of them are currently running queries
- what sessions are in each group
- which requests are in each group
- the average CPU time per request in each resource pool to date
- the system utilizing cache, compile and total memory within each pool and across all pools
- what requests are running in the classifier function