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, 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
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
-
Fixed part: 987 bytes
-
Variable part: 0 bytes
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 |