Minion collects all RG DMVs.
The list of DMVs collected:
| DMV | Minion Table |
|---|---|
| sys.dm_resource_governor_configuration | Collector.ResourceGovernorConfiguration * |
| sys.resource_governor_configuration | |
sys.dm_resource_governor_external_resource_pool_affinity | Collector.ResourceGovernorExternalResourcePoolAffinity |
| sys.dm_resource_governor_resource_pool_affinity | Collector.ResourceGovernorResourcePoolAffinity |
| sys.dm_resource_governor_external_resource_pools | Collector.ResourceGovernorExternalResourcePools |
| sys.dm_resource_governor_resource_pools | Collector.ResourceGovernorResourcePools |
| sys.dm_resource_governor_resource_pool_volumes | Collector.ResourceGovernorResourcePoolVolumes |
| sys.dm_resource_governor_workload_groups | Collector.ResourceGovernorWorkloadGroups |
* Notice above that the first 2 DMVs are mapped to the same Minion table. This is to give you a simple view of active and pending settings.
The RG started in 2008 and has improved since then with added tables and columns. Therefore, it makes sense that all tables and columns are available for every version of SQL Server. So if you're getting unexpected NULLs, check the Microsoft documentation to make sure the info is valid for your version of SQL server.
This collection also brings in a new table, Collector.ServersDetail. This table holds some extended info on rows in the dbo.Servers table. Unlike the Servers table, ServersDetail is in the Collector schema. This is because the items here are more volatile in nature as you can turn the RG on/off at will much simpler than you can change the properties in the Servers table. It's also to keep the Servers table from getting too wide. The data in the Collector.ServersDetail table is populated by the SQLVersionGet collection.
This collection has also brought a change to the SQLVersionGet collection, and the ConnParameterQB.exe in the Collector folder. As mentioned above the SQLVersionGet collection now gathers the info in the ServersDetail table.
ConnParameterQB.exe has had a new CollectionType of 'RG' added to support the Resource Governor collection.
This new CollectionType ensures that only servers with RGEnabled are queried so that it doesn't waste tons of time moving through servers that it doesn't need to.
And of course, all the new Collector tables have the usual Current and Previous views.
Related
Troubleshoot: Resource Governor Collection