Config Detail (PD_CD)
Function
The Config Detail (PD_CD) record indicates information related to Microsoft SQL Server environment setting options. One record is created for each environment setting option.
This is a multi-instance record.
Default and changeable values
Item | Default value | Changeable |
---|---|---|
Collection Interval | 60 | Y |
Collection Offset | 0 | Y |
Log | No | Y |
LOGIF | (Blank) | Y |
ODBC key field
PD_CD_NAME
Lifetime
From creation to deletion of a Microsoft SQL Server instance
Record size
Fields
View name (Manager name) | Description | Summary | Format | Delta | Data source |
---|---|---|---|---|---|
Config Value (CONFIG_VALUE) | Environment setting option value | -- | long | No | sp_configure.config_value |
Current Run Value (RUN_VALUE) | Environment setting option value (execution value at data collection) | -- | long | No | sp_configure.run_value |
Max Value (MAXIMUM) | Maximum value of environment setting option | -- | long | No | sp_configure.maximum |
Min Value (MINIMUM) | Minimum value of environment setting option | -- | long | No | sp_configure.minimum |
Name (NAME) | Name of environment setting option | -- | string(141) | No | sp_configure.name |
Record Time (RECORD_TIME) | Interval end time (GMT format) | -- | time_t | No | Remote Monitor Collector |
Record Type (INPUT_RECORD_TYPE) | Record type (always CD) | -- | char(8) | No | Remote Monitor Collector |
Start Time (START_TIME) | Interval start time (GMT format) | -- | time_t | No | Remote Monitor Collector |
VA DeviceID(VADEVICEID) | Device ID of virtual agent. | -- | string(256) | No | Remote Monitor Collector |