Format of record explanations

This chapter describes the records for PFM - RM for Microsoft SQL Server in alphabetical order. The explanation of each record consists of the following subsections:

Function

Provides an overview of the performance data that is stored in the record and includes important information that should be noted.

Default and changeable values

Consists of a table of the default values for the performance data under the collection conditions that are defined for the record, and indicates whether or not the values can be changed by the user. The table below lists and describes the items that appear in the Default and changeable values subsections. For details about each item in the table, see the chapter on management of operation monitoring data in the Job Management Partner 1/Performance Management User's Guide.

Table 5-1 Default and changeable values

ItemDefault valueChangeable
Collection IntervalPerformance data collection interval (in seconds)Y: Changeable
N: Not changeable
Collection Offset#1Offset value for starting performance data collection (in seconds). For details about offset values, see the chapter on management of operation monitoring data in the Job Management Partner 1/Performance Management User's Guide.
For collection start time for the performance data, see the chapter on the Performance Management functionality in the Job Management Partner 1/Performance Management Planning and Configuration Guide.
Log#2Whether or not collected performance data is stored in the Store database:
Yes: Store (however, if Collection Interval=0 is set, collected performance data is not stored).
No: Do not store.
LOGIFConditions for storing collected performance data in the Store database
#1
The range of values is from 0 to 32,767 (inclusive) seconds (within the value range specified for Collection Interval). This is used to distribute the collection processing workload because data collection is concentrated when multiple data items are collected. The data collection time that is recorded is the same as for the Collection Interval regardless of the value of Collection Offset.
If you change the value of Collection Offset, you should take into account the collection processing workload.
#2
The default values for each record are for remote agents. In PFM - RM for Microsoft SQL Server, the default values for group agents are "No".

ODBC key fields

Indicates the ODBC key fields that are required in order to use the record data stored in the Store database by using SQL statements with PFM - Manager. Some ODBC key fields are common to all records, and some are specific to each record. This section presents the ODBC key fields that are specific to each record. Only the multi-instance records have specific ODBC key fields.

For details about the ODBC key fields common to all records, see List of ODBC key fields in this chapter. For details about using ODBC key fields, see the chapter on linking to an ODBC-compliant application program in the Job Management Partner 1/Performance Management User's Guide.

Lifetime

Indicates the period during which consistency is guaranteed for the performance data that is collected in the record. For details about lifetimes, see the chapter on Performance Management functionality in the Job Management Partner 1/Performance Management Planning and Configuration Guide.

Record size

Indicates the amount of performance data that can be collected and stored in each record at one time.

Fields

Provides a table that describes the fields of each record. The table contains the following items: