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:
- Organization of this page
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 JP1/Performance Management User's Guide.
|
Item |
Default value |
Changeable |
|---|---|---|
|
Collection Interval |
Performance data collection interval (in seconds) |
Y: Changeable N: Not changeable |
|
Collection Offset#1 |
Offset value for starting performance data collection (in seconds). For details about offset values, see the chapter on management of operation monitoring data in the JP1/Performance Management User's Guide. For collection start time for the performance data, see the chapter on the Performance Management functionality in the JP1/Performance Management Planning and Configuration Guide. |
|
|
Log#2 |
Whether 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. |
|
|
LOGIF |
Conditions for storing collected performance data in the Store database |
|
|
Over 10 Sec Collection Time#3 |
Whether a certain system configuration can cause record collection to take 10 seconds or longer. Yes: Record collection might take 10 seconds or longer. No: Record collection does not take 10 seconds. |
- #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".
- #3
-
This property is displayed if the collection of historical data is prioritized over the display processing of real-time reports. For details, see the chapter on troubleshooting in the JP1/Performance Management User's Guide.
ODBC key fields
These fields display the primary keys that are necessary to use the data retrieved from records stored in the Store database on either PFM - Manager or PFM - Base. 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.
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 JP1/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:
-
PFM - View name (PFM - Manager name)
-
PFM - View name
Indicates the field name that is displayed with PFM - Web Console (PFM - View name).
-
PFM - Manager name
Field name (PFM - Manager name) to be specified in SQL statements when SQL statements are used from PFM - Manager to access the field data stored in the Store database.
You specify the record ID at the beginning of an SQL statement. For example, to specify the Disk Sorts (SORTS_DISK) field of the System Stat Summary (PD) record, specify PD_SORTS_DISK.
-
-
Description
Explanation of the performance data that is stored in the field.
Notes #1 and #2 in the table indicate the following:
- #1
-
A value in this field is the latest monitored value that the system being monitored returns at the time of data collection.
- #2
-
When this field is displayed in the historical report, the PFM - View name (Total) field is added.
For each field, the following methods of calculating performance data are available:
-
Calculations (such as averages or percentages) based on data collected in the current and previous intervals.
-
Calculations based on data collected in the current interval only. This data includes the values accumulated internally by the OS (the data marked as #1 in the table).
-
Calculations based on data in other fields (See Data source in the table of each record's fields.)
Unless otherwise noted, the value in each field is an unprocessed value that was collected at a specified data collection interval.
The following types of values are displayed in a historical report when records of the PI record type are summarized and displayed while the report interval setting is not "minute":
-
The average value for the summarized interval
-
The last collected value
-
The sum total of values
-
The minimum value
-
The maximum value
Unless otherwise noted, the value in each field displays the average for the summarized interval.
-
Summary
The summarization method (Summary rules) used by Remote Monitor Store when summarizing data. For details, see Summary rules in this chapter.
-
Format
Data type of the field value, such as double. For details about the data types, see List of data types in this chapter.
-
Delta
In contrast to the data collected as the cumulative value, the so-called delta is the data that indicates the changed amount. For details about delta, see Field values in this chapter.
-
Supported version
Indicates the Microsoft SQL Server version that can use the field.
If a version number is shown, the field is supported by that version and all subsequent versions. All means that all Microsoft SQL Server versions support the field. Not supported means that the field is not supported by Microsoft SQL Server.
-
Data source
Method used to obtain the field value or the source of the data. For details about field values, see Field values in this chapter.