This table holds extended info on all the servers in dbo.Servers. It holds data that can typically be considered more volatile than the properties in the dbo.Servers table so we put it in the Collector schema.
Column Name | Data Type | Description |
---|---|---|
ID | bigint | IDENTITY |
ExecutionDateTime | datetime | Date and time data was collected from server. |
InstanceID | bigint | InstanceID from dbo.Servers table. |
RGEnabled | bit | Whether or not the Resource Governor is enabled. |
HADREnabled | bit | Whether or not Availability Groups are enabled. |