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
Dirk
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