The capability of PFM - RM for Microsoft SQL Server to monitor operating status can be enhanced through linkage with JP1/ITSLM.
PFM - RM for Microsoft SQL Server provides default monitoring items specific to JP1/ITSLM for PFM - Manager to enable monitoring on JP1/ITSLM.
The default monitoring items provided by PFM - RM for Microsoft SQL Server for PFM - Manager are described in the following table.
In addition, PFM - RM for Microsoft SQL Server collects records corresponding to the value specified as the key for multi-instance records. For the corresponding collection key, see the collection result for each record.
Table K-1 Default monitoring items provided by PFM - RM for Microsoft SQL Server for PFM - Manager
Display name in JP1/ITSLM | Description | Record (Record ID) | Key (PFM-Manager name) | Field name |
---|---|---|---|---|
Cache Hit rate | Monitors the ratio of requests found in the data cache to disk read operations | Server Overview (PI_SERV) | -- | CACHE_HIT_RATIO |
CPU usage rate | Monitors the ratio of CPU consumption by the current session. | Global Server Summary (PI) | -- | PERC_BUSY |
Database free space rate | Monitors the percentage of free space in each database. | Database Space Detail (PD_DS) | DB_NAME, DBID | PERC_FREE |
Log space usage rate | Monitors the percentage of transaction log space that is being used by the transaction log | Transaction Log Overview (PI_TLOG) | DB_NAME | LOG_SPACE_USED_PCT |
To provide the default monitoring items for PFM - Manager, you need to copy the setup file and execute the setup command. For details, see 2.1.4(1) Registering PFM - RM for Microsoft SQL Server.