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.

Notes:
  • If, before the PD_IA record is collected, the maximum number of sessions that have been given permission to connect to the Microsoft SQL Server instance has been reached, the Availability field in the PD_IA record indicates 0 (inactive), but the other records might be obtained normally.
  • If the Microsoft SQL Server instance stops operating during record collection, the Availability field in the PD_IA record indicates 0 (inactive), but the other records might be obtained normally.
  • If the Microsoft SQL Server instance that was inactive during record collection starts operating, the Availability field in the PD_IA record indicates 1 (active), but the other records might not be obtained.
  • If an Instance Availability (PD_IA) record is created while Microsoft SQL Server is inactive, the next creation of an Instance Availability (PD_IA) record will be skipped when the following condition is satisfied:
    Condition:
    -LOGIN_TIMEOUT >= collection-interval-of-the-Instance-Availability(PD_IA)-record
  • PFM - RM for SQL Server collects performance data of the record field size from Microsoft SQL Server. Therefore, if Microsoft SQL Server contains data that exceeds the field size of Message field, the last character of the performance data might be unreadable.

Default and changeable values

ItemDefault valueChangeable
Collection Interval60Y
Collection Offset0Y
LogNoY
LOGIF(Blank)Y

ODBC key field

None

Lifetime

None

Record size

Fields

View name
(Manager name)
DescriptionSummaryFormatDeltaData source
Availability
(AVAILABILITY)
Availability status; valid value is 0 (inactive) or 1 (active)--wordNoRemote Monitor Collector
Collect Time
(COLLECT_TIME)
Time spent connecting to and disconnecting from Microsoft SQL Server (milliseconds)--ulongNoRemote 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)NoRemote Monitor Collector
Record Time
(RECORD_TIME)
Interval end time (GMT format)--time_tNoRemote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)
Record type (always IA)--char(8)NoRemote Monitor Collector
Start Time
(START_TIME)
Interval start time (GMT format)--time_tNoRemote Monitor Collector
VA DeviceID(VADEVICEID)Device ID of virtual agent.--string(256)NoRemote Monitor Collector