Hitachi

JP1 Version 12 JP1/Performance Management - Remote Monitor for Microsoft(R) SQL Server Description, User's Guide and Reference


Instance Availability (PD_IA)

Organization of this page

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, PFM - 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 Microsoft 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

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

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