There may be times when you're not getting data you think you should be. This will discuss the types of issues that may come up.
Why am I not getting RG data from my server?
There are a couple reason for this. First, if you just recently turned on the RG for a server, then that metadata may not have made it to Minion yet. The metadata is collected by the SQLVersionGet collection and stored in Collector.ServersDetail.RGEnabled. The SQLVersionGet collection uses the Collector.ServersDetailCurrent view to get the metadata setting for each server. So the best place to start is to query Collector.ServersDetail and make sure the RGEnabled column for the server is 1. If not, then you've got an issue with the SQLVersionGet collection itself. If the server doesn't have a row in this table then that collection may not have run since you enabled RG for that server. In this case you can either run it manually for that single server, or you can run the job for that SLA. This should populate this metadata and you should now collect the RG data. Running the collector manually is preferable so you can see if there are any errors.
Second, you could be getting errors on the SQLVersionGet or the RGPropertiesGet collections.
For each one of these, run them manually from the cmdline to see which errors occur.
All the columns in my ResourceGovernor* tables aren't being populated.
The most common cause of this is that not all column are available for all versions of SQL Server. Check with MS documentation to make sure the version of your server supports the columns missing data.
If it does support those columns and you're not getting data for them, contact support.
Related