Appendix K. Linking with JP1/ITSLM

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/ITSLMDescriptionRecord
(Record ID)
Key
(PFM-Manager name)
Field name
Cache Hit rateMonitors the ratio of requests found in the data cache to disk read operationsServer Overview
(PI_SERV)
--CACHE_HIT_RATIO
CPU usage rateMonitors the ratio of CPU consumption by the current session.Global Server Summary
(PI)
--PERC_BUSY
Database free space rateMonitors the percentage of free space in each database.Database Space Detail
(PD_DS)
DB_NAME, DBIDPERC_FREE
Log space usage rateMonitors the percentage of transaction log space that is being used by the transaction logTransaction Log Overview
(PI_TLOG)
DB_NAMELOG_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.