![[Contents]](FIGURE/CONTENT.GIF)
Job Management Partner 1 Version 10, Job Management Partner 1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference
![[Glossary]](FIGURE/GLOSS.GIF)
![[Index]](FIGURE/INDEX.GIF)
![[Back]](FIGURE/FRONT.GIF)
![[Next]](FIGURE/AFTER.GIF)
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 |
Copyright (C) 2013, Hitachi, Ltd.
Copyright (C) 2013, Hitachi Solutions, Ltd.