Config Detail (PD_CD)
- Organization of this page
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 |
|
Over 10 Sec Collection Time |
No |
N |
ODBC key field
PD_CD_NAME
Lifetime
From creation to deletion of a Microsoft SQL Server instance
Record size
-
Fixed part: 681 bytes
-
Variable part: 157 bytes
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 |
Agent Collector |
|
Record Type (INPUT_RECORD_TYPE) |
Record type (always CD) |
-- |
char(8) |
No |
Agent Collector |
|
Start Time (START_TIME) |
Interval start time (GMT format) |
-- |
time_t |
No |
Agent Collector |