This blog is part of the blog series named SQL Server Monitoring.
Purpose
To get a quick overview of the configuration of the Resource Governor.
Report
The report are showing 6 tables where each are showing selected information about the resource governor and its configuration and settings.
- Classifier definitions
- Resource pools
- Workload groups
- Resource pool affinity
- External resource pool affinity
- External resource pools
Sources
This feature queries a number of DMV’s.
Model
The model for the report uses the facts [Resource governor configuration], [Resource governor external resource pool affinity], [Resource governor external resource pools], [Resource governor resource pool affinity], [Resource governor resource pools] and [Resource governor workload groups].
It is the same model that are used by the Instance configuration and Instance status reports.
Configuration
The report uses the same data as used by the Instance configuration report.
