Instance Availability (PD_IA)
Function
The Instance Availability (PD_IA) record provides information on the availability of the Microsoft SQL Server instance. Only one record is created. To create this record, RM for Microsoft SQL Server attempts to connect to Microsoft SQL Server and then, after a successful connection, immediately disconnects.
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
None
Lifetime
None
Record size
Fields
View name (Manager name) | Description | Summary | Format | Delta | Data source |
---|---|---|---|---|---|
Availability (AVAILABILITY) | Availability status; valid value is 0 (inactive) or 1 (active) | -- | word | No | Remote Monitor Collector |
Collect Time (COLLECT_TIME) | Time spent connecting to and disconnecting from Microsoft SQL Server (milliseconds) | -- | ulong | No | Remote Monitor Collector |
Message (MESSAGE) | Character string of the error message when an attempt to connect to Microsoft SQL Server fails. This is blank when the connection is successful. | -- | string(300) | No | Remote Monitor Collector |
Record Time (RECORD_TIME) | Interval end time (GMT format) | -- | time_t | No | Remote Monitor Collector |
Record Type (INPUT_RECORD_TYPE) | Record type (always IA) | -- | 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 |