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.
Sources
This feature queries a number of DMV’s.
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
Model
The model for the report uses the facts [Agent alerts], [Agent jobs], [Instance configuration], [Instance configuration history], [Instance dump files], [Instance hardware], [Instance hardware history], [Instance services], [Instance suspect pages], [Resource governor configuration], [Resource governor external resource pool affinity], [Resource governor external resource pools], [Resource governor resource pool affinity], [Resource governor resource pools], [Resource governor workload groups], [Trace flags] and [Trace flags history].
It is the same model that are used by the Instance configuration and Instance status reports.
Configuration
There is no configuration for this feature.
Scheduling
The default schedule for the feature is once every hour.
Retention
The default retention for the table dbo.fhsmInstanceState is 1.825 days (5 years).
