K. Linking with JP1/SLM
The capability of PFM - Agent for Microsoft SQL Server to monitor operating status can be enhanced through linkage with JP1/SLM.
PFM - Agent for Microsoft SQL Server provides default monitoring items specific to JP1/SLM for PFM - Manager to enable monitoring on JP1/SLM.
The default monitoring items provided by PFM - Agent for Microsoft SQL Server for PFM - Manager are described in the following table.
In addition, PFM - Agent 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.
|
Display name in JP1/SLM |
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 - Agent for Microsoft SQL Server.