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.