(DI-2111) Complete List of Default KPIs
- SNP
Owned by SNP
Nov 05, 2021
80 min read
Loading data...
This is a complete list of KPIs:
| KPI | Description | Long description | Monitoring area | KPI area (collected for) | Server selection (Server specification) | Collected on | Collector | Profile | Recommended mon.period |
| APP_LOGS | Number of application logs | The KPI value represents a count of application logs. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_APPLOG | ||
| ARFC_FREE | Number of available (free) WP for aRFC resources | Calculates resources of an application server. Collects the number of available work processes for asynchronous RFC resources. For more information go to: https://help.sap.com/saphelp_nw70ehp2/Helpdata/en/7f/06363dc992752de10000000a114084/frameset.htm | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ARFC | 5 MI | |
| ARFC_FREE_P | Percentage of available (free) WP for aRFC resources | Calculates resources of an application server. Collects percentage of available work processes for asynchronous RFC resources. For more information go to: https://help.sap.com/saphelp_nw70ehp2/Helpdata/en/7f/06363dc992752de10000000a114084/frameset.htm | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ARFC | DEF_5MIN | 5 MI |
| ARFC_WAIT (OBSOLETE) | Wait time of aRFC for free WP | If no more resources are available, the system offers the caller a wait time. The maximum wait time (max_wait) is set by using the profile parameter rdisp/rfc_max_wait_time. The default is 15 seconds. The wait time is calculated as follows: quota = resource * parameter value / 100 count = current usage of the resource As no resources are provided, count > quota wait = min (max(1,count-quota), max_wait). | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ARFC | ||
| BAT_DB_INSERT_AG | Average DB insert | Insertion is a process, where the array inserts N entries from the internal table. N is by default 10 000 entries but can be changed with the parameter NUM_RECORDS of the collector /DVD/MON_BAT_CL_DB. This KPI shows the average database insert. | BENCH | SYS | any server | Central system | /DVD/MON_BAT_CL_DB | DEF_5MIN | 5 MI |
| BAT_DB_INSERT_MS | DB Insertion benchmark | Insertion is a process, where the array inserts N entries from the internal table. N is by default 10 000 entries but can be changed with the parameter NUM_RECORDS of the collector /DVD/MON_BAT_CL_DB. Database insertion benchmark displays this KPI. | BENCH | SYS | any server | Remote system | /DVD/MON_BAT_CL_DB | DEF_5MIN | 5 MI |
| BAT_DB_SELECT_AG | Average DB select | Select - with WHERE clause on the primary key, such as to select all N entries. N is by default 10 000 entries but can be changed with the parameter NUM_RECORDS of the collector /DVD/MON_BAT_CL_DB. Database select and its average are measured by KPI with the name BAT_DB_SELECT_AG. | BENCH | SYS | any server | Central system | /DVD/MON_BAT_CL_DB | DEF_5MIN | 5 MI |
| BAT_DB_SELECT_MS | DB Select benchmark | Select - with WHERE clause on the primary key, such as to select all N entries. N is by default 10 000 entries but can be changed with the parameter NUM_RECORDS of the collector /DVD/MON_BAT_CL_DB. This KPI shows the database select benchmark. | BENCH | SYS | any server | Remote system | /DVD/MON_BAT_CL_DB | DEF_5MIN | 5 MI |
| BAT_DB_UPDATE_AG | Average DB update | Update - with WHERE clause on the primary key, such as to update single non-key field on N entries. N is by default 10 000 entries but can be changed with the parameter NUM_RECORDS of the collector /DVD/MON_BAT_CL_DB. Process of average DB update is displayed by this KPI. | BENCH | SYS | any server | Central system | /DVD/MON_BAT_CL_DB | DEF_5MIN | 5 MI |
| BAT_DB_UPDATE_MS | DB Update benchmark | Update - with WHERE clause on the primary key, such as to update single non-key field on N entries. N is by default 10 000 entries but can be changed with the parameter NUM_RECORDS of the collector /DVD/MON_BAT_CL_DB. Database update benchmark is processed this KPI. | BENCH | SYS | any server | Remote system | /DVD/MON_BAT_CL_DB | DEF_5MIN | 5 MI |
| BO_PROBE_BI_LAUNCH_PAD_EXETIME | BI_Launch_pad Probe Exec. Time | BOBJ | SER | only external server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BO_PROBE_BI_LAUNCH_PAD_RESULT | BI_Launch_pad Probe Result | BOBJ | SER | only external server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BO_PROBE_CMS_CACHE_EXETIME | CMS Cache Probe Exec. Time | BOBJ | SER | only external server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BO_PROBE_CMS_CACHE_RESULT | CMS Cache Probe Result | BOBJ | SER | only external server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BO_PROBE_CMS_DB_CONN_EXETIME | CMS DB Connection Probe Exec. Time | BOBJ | SER | only external server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BO_PROBE_CMS_DB_CONN_RESULT | CMS DB Connection Probe Result | BOBJ | SER | only external server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BO_PROBE_CMS_LOGON_EXETIME | CMS Logon Probe Exec. Time | BOBJ | SER | only external server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BO_PROBE_CMS_LOGON_RESULT | CMS Logon Probe Result | BOBJ | SER | only external server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BO_PROBE_CMS_PING_EXETIME | CMS Ping Probe Exec. Time | BOBJ | SER | only external server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BO_PROBE_CMS_PING_RESULT | CMS Ping Probe Result | BOBJ | SER | only external server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BO_PROBE_CRS_PCS_EXETIME | Crystal Rep. Serv. through Page and Cache Ser. Exec. Time | BOBJ | SER | only external server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BO_PROBE_CRS_PCS_RESULT | Crystal Rep. Serv. through Page and Cache Ser. Result | BOBJ | SER | only external server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BO_PROBE_CRS_RAS_EXETIME | Crystal Reports Service through RAS Probe Exec. Time | BOBJ | SER | only external server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BO_PROBE_CRS_RAS_RESULT | Crystal Reports Service through RAS Probe Result | BOBJ | SER | only external server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BO_PROBE_WEBI_EXETIME | Web Intelligence Probe Exec. Time | BOBJ | SER | only external server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BO_PROBE_WEBI_RESULT | Web Intelligence Probe Result | BOBJ | SER | only external server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BO_TOP_HIER_ENTNOD_HS | Enterprise Nodes Health State | BOBJ | SYS | any server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BO_TOP_HIER_SERCAT_ANASER_HS | Analysis Services Health State | BOBJ | SYS | any server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BO_TOP_HIER_SERCAT_CONSER_HS | Connectivity Services Health State | BOBJ | SYS | any server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BO_TOP_HIER_SERCAT_CORSER_HS | Core Services Health State | BOBJ | SYS | any server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BO_TOP_HIER_SERCAT_CRYREPSER_HS | Crystal Reports Services Health State | BOBJ | SYS | any server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BO_TOP_HIER_SERCAT_DASSER_HS | Dashboards Services Health State | BOBJ | SYS | any server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BO_TOP_HIER_SERCAT_DATFEDSER_HS | Data Federation Services Health State | BOBJ | SYS | any server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BO_TOP_HIER_SERCAT_HS | Service Categories Health State | BOBJ | SYS | any server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BO_TOP_HIER_SERCAT_PROMANSER_HS | Promotion Management Services Health State | BOBJ | SYS | any server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BO_TOP_HIER_SERCAT_WEBISER_HS | Web Intelligence Services Health State | BOBJ | SYS | any server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BO_TOP_HIER_SERGRP_HS | Server Groups Health State | BOBJ | SYS | any server | Remote system | /DVD/MON_BO_CL_COL_BOBJ | BO_1MIN_PR | 1 MI | |
| BTC_NUM_DELAYED | Number of delayed background jobs ( => 60 seconds) | The KPI value represents a count of background jobs that waiting for the free work process for more than 60 seconds. | SAPSYS | SYS | only application server | Remote system | /DVD/MON_BTC_CL_COL_JOBS | DEF_5MIN | 5 MI |
| BTC_NUM_FAILED | Number of failed background jobs | The KPI value represents a count of background jobs that failed. | SAPSYS | SYS | only application server | Remote system | /DVD/MON_BTC_CL_COL_JOBS | DEF_5MIN | 5 MI |
| BTC_NUM_LONGRUN | Number of background jobs running too long ( >= 10 minutes) | The KPI value represents a count of background jobs that running more than 10 minutes. | SAPSYS | SYS | any server | Remote system | /DVD/MON_BTC_CL_COL_JOBS | DEF_5MIN | 5 MI |
| BW_12503CNT | Javastack: count number of 12503 | JAVAST | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_JAVAST_EVT | BW_5MIN | 5 MI | |
| BW_12503CNT_NOTA | Javastack: count number of 12503 on not authorized node | JAVAST | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_JAVAST_EVT | BW_5MIN | 5 MI | |
| BW_12503CXMN_AVG | Javastack: count number of 12503 Xminute-avg per node hourly | JAVAST | SYS | any server | Central system | /DVD/MON_BW_CL_COL_JAVAST_EVT | BW_5MIN | 5 MI | |
| BW_12503CXMN_MAX | Javastack: count number of 12503 Xminute-maximum node hourly | JAVAST | SYS | any server | Central system | /DVD/MON_BW_CL_COL_JAVAST_EVT | BW_5MIN | 5 MI | |
| BW_12503CXMN_MIN | Javastack: count number of 12503 Xminute-minimum node hourly | JAVAST | SYS | any server | Central system | /DVD/MON_BW_CL_COL_JAVAST_EVT | BW_5MIN | 5 MI | |
| BW_12503CXMN_MNV | Javastack: count number of 12503 Xminute-variance min node | JAVAST | SYS | any server | Central system | /DVD/MON_BW_CL_COL_JAVAST_EVT | BW_5MIN | 5 MI | |
| BW_12503CXMN_MXV | Javastack: count number of 12503 Xminute-variance max node | JAVAST | SYS | any server | Central system | /DVD/MON_BW_CL_COL_JAVAST_EVT | BW_5MIN | 5 MI | |
| BW_12503HEAPMAX | Javastack : Max value of heap for all nodes | There are 10 nodes per system BW, instead of capturing and storing the memory of each node, we capture the memory of the most loaded. If the value remains at 84%, the memory consumption is too high. Check event 12505 above. | JAVAST | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_JAVAST_EVT | BW_5MIN | 5 MI |
| BW_12503MISSUSR | Javastack : No of users with 12502 without 12503 after x min | When a web template v7 starts, it creates an entry 12502 in rsddstat_olap. In the end, it creates an entry 12503. If a template fails on Javastack, there is a 12502 without 12503. There is a timeout after 15 minutes so a Javastack session cannot take more than 15 minutes. However, a Javastack session should take only a few seconds to 1 minute as it’s a user's tool (not batch). These indicators count how many users have sessions 12502 not followed by 12503 after 5 minutes, on the same node. For all KPIs on Javastack, we need at least BW730SP8 and BI JAVA SP7 Patch 30. See the SAP note 1069253. | JAVAST | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_JAVAST_EVT | BW_5MIN | 5 MI |
| BW_12505NO | Javastack : No of queries rejected (stat 12505) | When memory on Javastack is above rsadmin threshold, Javastack will reject the request from the user (the template will not run), and instead, it will create an entry in rsddstat_olap event 12505. This KPI should be zero. If there is an issue (e.g., GC stuck) on the memory of the Javastack, this KPI will be greater than zero. | JAVAST | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_JAVAST_EVT | BW_5MIN | 5 MI |
| BW_12640NO | Javastack : No of Javastack cache refresh (stat 12640) | Cache refresh is done at Javastack restart (or forced manually to refresh rsadmin parameter but this should be exceptional). If no manual refresh is done, this indicator counts the Javastack restarts. | JAVAST | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_JAVAST_EVT | BW_5MIN | 5 MI |
| BW_9000DMMISS | Number of queries failing on DM (BWA, DB, HANA) | When a query fails on datamanager (DB2 or BWA), there is an entry in rsddstat_olap with event 9000 but no entries in rsddstat_dm. Queries can fail on DB2 (e.g., dump signal 11) or on BWA (e.g., if all memory is used), or on Hana. The count shows how stable (or unstable) is DB and BWA. A restart of BWA will make several queries fail so will increase this value, like a reorg or a memory issue or a BWA index corrupted, or query above the safety belt of 40 million cells. No reaction is expected if there are only one or two failures, but if many queries are failing at the same time it’s a general issue that needs to be addressed and reoccurrence must be prevented. | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_RSDDSTATS | BW_5MIN | 5 MI |
| BW_AGGR_USAGE | Aggregate usage | Every 5 minutes we calculate the number of aggregate hits by comparing rsddstataggrdir field "usage" per aggregate with the previous snapshot. And the table /DVD/MON_BWAGGRU is updated with the number of hits per aggregate per day. This is to find which aggregates are not used and can be deactivated to improve the runtime of changerun and rollup. | BW | SYS | only application server | Remote system | /DVD/MON_BW_CL_COL_AGGR_USAGE | BW_5MIN | 5 MI |
| BW_D_IP_ABTHRS | Yesterday's Number of IPs with more than X packets | It is the number of request that was running yesterday (either started or finished yesterday) with more than 100 packets (100 is a parameter of the collector and can be changed). The detail can be seen in the detail tab, "BW Daily stats on Infopackages" or in the table /DVD/MON_BWDIP. The KPI is using the following tables or could use in the future the following tables: RSMONICDP : RNR, cube, request, timestamp, rec_INSERT. index TSP on the timestamp RSREQDONE RNR > ZPAK</BR> RSLDPIO -ZPAK > DataSource.... oltptyp = M master data, D transactional RSDDSTATWHM - RNR runtime rsmonfact - not used as it's too large. Can be used in the future to calculate the UR runtime of each packet</BR> rsmonmess - take min timestamp from second line (first line is extraction time) = starttime and max = endtime per packet</BR> rsiccont - targets per request For the DTP, the following table could be used to enhance the KPI or a new KPI. RSBKREQUEST gives all DTP requests (number of rows, time start, end) and DTP number RSBKDTP gives the details for the DTP (source and target) RSBKDATAPAKID for each packet of a DTP request provides a number of rows extracted, processed | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_GET_D_IP | BW_1DAY | 1 DA |
| BW_DURATTRIBCHAN | BW duration running attribute changerun | During changerun, many BW jobs are locked so it is important that the attribute changerun is not too long. This KPI calculates the runtime of the currently running job BI_PROCESS_ATTRIBCHAN, BI_STRU* or BI_CHANGERUN_RESTART. The value of the KPI is calculated only for the running jobs and not the job finished; so the final actual runtime will be higher than the last value captured but in the same range. If the runtime is too long, administrators can be informed and can decide to drop aggregates. If the adjust is too long running (i.e., jobg BICHNG), check the runtime of activation of MD (BIACTI jobs) and create DB indexes if needed, and check that the number of changes in IO is normal (same number of changes in the source system and not increased by a bug or conflicting loads). | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_BATCH | BW_5MIN | 5 MI |
| BW_DURCOMPRESS | BW duration of longest running cube compression | This indicator shows the longest running cube compression, i.e., the longest running job BI_*COMP*. The value of the KPI is calculated only for the running jobs and not the job finished; so the final actual runtime will be higher than the last value captured but in the same range. By calculating this value every few minutes, allow to raise an alert if there is a long running cube compression and take ABAP, SQL traces to investigate the performance of this cube compression. | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_BATCH | BW_5MIN | 5 MI |
| BW_DURDBINDEX | BW duration of longest running DB indexing | The SAP default is to drop indexes before the load and recreate the index after the load in the process chain. This is fine for full loads but for delta, it can take hours to recreate the index. The time saved to load a small delta can be much lower than the time to rebuild. This indicator shows the longest running job BI_PROCESS_INDEX*. The value of the KPI is calculated only for the running jobs and not the job finished; so the final actual runtime will be higher than the last value captured but in the same range. By calculating this value every few minutes, this allows correlating those long running job and another issue on the system. If this is not required; this indicator can be deactivated and replaced by a daily check of the job BI_PROCESS_INDEX*. | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_BATCH | BW_5MIN | 5 MI |
| BW_DURLOADING | BW duration of longest running DTP | This indicator shows the longest running DTP, i.e., the longest running job BIDTPR_*. The value of the KPI is calculated only for the running jobs and not the job finished; so the final actual runtime will be higher than the last value captured but in the same range. By calculating this value every few minutes, allow to raise an alert if there is a long running DTP and take ABAP, SQL traces to investigate the performance of this DTP. | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_BATCH | BW_1HOUR | 1 HO |
| BW_DURLOADIP | BW duration of longest running InfoPackage | This indicator shows the longest running InfoPackage. From the enqueue of the running IP, we check the start time and calculate the delay between the start time and current time. By calculating this value every few minutes, allow to raise an alert if there is a long running InfoPackage and take ABAP, SQL traces to investigate the performance of this InfoPackage. See the table BW InfoPackages to see for the top N requests, the request number, number of packets, runtime, InfoPackage, datasource. Only InfoPackages with more than 50 packets or duration greater than 1800 seconds are recorded. Sometimes values are incorrect as no enqueue will be visible, this can lead to missing data but the trend should be always correct. | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_GET_IP | BW_1HOUR | 1 HO |
| BW_DURMDACTIVAT | BW duration of longest running MD activation | This indicator shows the longest running Master Data activation job during changerun, i.e., the longest running job BIACTI_*. The value of the KPI is calculated only for the running jobs and not the job finished; so the final actual runtime will be higher than the last value captured but in the same range. By calculating this value every few minutes, allow to raise an alert if there is a long running MD activation and take SQL traces to create the required index (usually CHANGED OBJVERS) on table P,Q,X,Y. | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_BATCH | BW_1HOUR | 1 HO |
| BW_DURODSACTIVAT | BW duration of longest running ODS activation | This indicator shows the longest running ODS (DSO) activation job, for the DSO where activation is done in batch and with at least 2 jobs in parallel (i.e., runtime of the running BIBCTL* jobs). The value of the KPI is calculated only for the running jobs and not the job finished; so the final actual runtime will be higher than the last value captured, but in the same range for the job BIBCTL that are slow. By calculating this value every few minutes, allow to raise an alert if there is a long running DSO activation and take SQL traces to analyze the issue (it can be the system hanging due to backup hang, lockwait, network issue, missing DB index, missing DB stats, etc.). For packet size of 20.000 rows, normal runtime should be between 20 and 60 sec. Everything above 500 sec should be investigated. | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_BATCH | BW_1HOUR | 1 HO |
| BW_IP_MAX_PACKET | BW IP max number of packets (multiplied by the number of targets) | InfoPackage loads spend too much on enqueues when the number of packets multiplied by the number of targets is more than 1000. We can have 500 packets and one target without performance issues, but if we have 500 packets and 10 targets, then most of the time will be spent on enqueue and not on processing the data. The number of packets not multiplied by the number of targets is not relevant and therefore not saved as a KPI. Below, when we refer to a number of packets, it’s always multiplied by the number of targets. These indicators show the highest number of packets (multiplied by the number of targets) in the running InfoPackages. From the enqueue of the running IP, we check the packet number that we can find in the monitor and we multiply it by the number of targets for this IP. If there are two IPs running with more than 1000 small packets, there are so many ENQ processed that we have situations where the system became very slow and rapidly 100% of the DIA WP were used. By calculating this value near real-time, allows us to raise an alert and review the packet size (roosprms), number of rows in the IP. For full recovery loads, if the number of packets will be very high, it can be faster to kill the load and repeat it with fewer packets. See tab « details » - « BW InfoPackages » to see for the top N requests, the request number, number of packets, the number of targets, number of packets multiplied by the number of targets, runtime, InfoPackage, Infosource, source, Datasource. | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_GET_IP | BW_1HOUR | 1 HO |
| BW_NR_MAX_DIFF | Maximum from an incremental difference of all number ranges | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_NUM_RANGE | BW_1DAY | 1 DA | |
| BW_NR_MAX_SPEED | Maximum from an incremental speed of number ranges per day | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_NUM_RANGE | BW_1DAY | 1 DA | |
| BW_NR_OVER_THR | Count of number range which is over the threshold | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_NUM_RANGE | BW_1DAY | 1 DA | |
| BW_NR_TOTAL_DIFF | Maximum from an incremental difference of all number ranges | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_NUM_RANGE | BW_1DAY | 1 DA | |
| BW_NR_TOTAL_SPEE | Incremental speed from all number ranges per day | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_NUM_RANGE | BW_1DAY | 1 DA | |
| BW_PC_STEP_COUNT | BW PC step count | Number of steps that finished since the last execution of the agent. | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_PC | BW_1HOUR | 1 HO |
| BW_PC_STEP_ERR | BW PC step error | Number of steps that finished in error since the last execution of the agent. If there are several steps in error in the last x minutes; it can show a general issue on the system (all BTC or DIA used, transaction log full, rollup failed as locked by failed CR). | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_PC | BW_1HOUR | 1 HO |
| BW_ETL_EXCEEDED_PC | Number of long running Process chains | Total number of currently running Process chains in which runtime exceeded the maximum time limit for its execution. | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_ETL_PC | BW_1HOUR | 1 HO |
| BW_ETL_FAILED_PC | Number of failed Process chains | Total number of failed Process chains. | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_ETL_PC | BW_1HOUR | 1HO |
| BW_ETL_FINISHED_PC | Number of successfully finished Process chains | Total number of successfully finished Process chains | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_ETL_PC | BW_1HOUR | 1 HO |
| BW_ETL_RUNNING_PC | Number of running Process chains | Total number of currently running Process chains | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_ETL_PC | BW_1HOUR | 1 HO |
| BW_QUERY_ERROR | Number of erroneous BW Queries | Total number of query executions which ended with an error. | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_QUERY_RT | BW_1HOUR | 1 HO |
| BW_QUERY_LONG_RUN | Number of long-running BW Queries | Total number of queries that are running longer than the defined threshold. | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_QUERY_RT | BW_1HOUR | 1 HO |
| BW_QUERY_RUNTIME | Number of executed BW Queries | Total number of BW query executions. | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_QUERY_RT | BW_1HOUR | 1 HO |
| BW_RSICCONT_GR12 | Forecast RSICCONT Growth in 12 months | The admin table RSICCONT contains one entry per "load request", each request goes in one provider. When there are too many rows in table RSICCONT for the same provider, the loads/monitor will generate many ENQ and it will slow down the system. This KPI is a forecasted value in 12 months. Looking at the speed of increase of the number of rows in RSICCONT over a month, a forecasted growth is calculated. The forecast is adjusted every day. | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_RSICCONT | BW_1DAY | 1 DA |
| BW_RSICCONT_MX12 | Forecast RSICCONT Max number of entries per cube in 12 months | The admin table RSICCONT contains one entry per "load request", each request goes in one provider. When there are too many rows in the table RSICCONT for the same provider, the loads/monitor will generate many ENQ and it will slow down the system. This KPI is a forecasted value in 12 months. Looking at the speed of increase of the number of rows in RSICCONT over a month, a forecasted growth is calculated (see KPI definition "RSICCONT Growth in 12 months"). The current number of rows in RSICCONT plus the forecasted growth gives the forecasted number in 12 months. Table /DVD/MON_BWRSICC in the satellite system will give you the number of entries per target. When the current value or forecasted value is above 6-7000, consider using report RSSM_REDUCE_REQUESTLIST (check OSS Note 1431315 - P24: Reducing very large request lists in InfoCubes and DSOs). | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_RSICCONT | BW_1DAY | 1 DA |
| BW_RSMONMESSPAC | BW Sum max number of packets for all running PSA | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_GET_IP | BW_1HOUR | 1 HO | |
| BW_SID_GR12 | Forecast SID Growth in 12 months | BW | SYS | only application server | Remote system | /DVD/MON_BW_CL_COL_SID_GROWTH | BW_1DAY | 1 DA | |
| BW_SID_MX12 | Forecast SID Max level in 12 months | BW | SYS | only application server | Remote system | /DVD/MON_BW_CL_COL_SID_GROWTH | BW_1DAY | 1 DA | |
| BW_SSQL_ALLNO | SQL-Total number of subqueries | Number of queries on the DB (in fact running SQL statement, op mode 0) to correlate with the performance issue if needed. | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_RSDDSTATS | BW_1HOUR | 1 HO |
| BW_SSQL_ALLTIM | SQL-Total time spent on subqueries | Cumulated time of all queries running on the DB (in fact running SQL statement, op mode 0) to correlate with performance issue if needed. | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_RSDDSTATS | BW_1HOUR | 1 HO |
| BW_SSQL_SQAR | SQL-Average runtime of small subqueries | Queries are split into subqueries, one per cube. Runtimes of each subquery are available in the table rsddstat_olap for the query with the option save "all" stats. Per definition, small subqueries are scanning less than 10 million rows and returning less than 10.000 rows. This KPI is the average runtime of the small queries. | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_RSDDSTATS | BW_1HOUR | 1 HO |
| BW_SSQL_SQLO | SQL-No of small subqueries long running (e.g., > 10 SEC) | This KPI is the number of small queries running for more than 10 sec. | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_RSDDSTATS | BW_1HOUR | 1 HO |
| BW_SSQL_SQNO | SQL-No of small subqueries | This KPI is the number of small subqueries. | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_RSDDSTATS | BW_1HOUR | 1 HO |
| BW_SUBQ_ALLNO | nonSQL-Total number of subqueries (BWA or HANA) | Number of queries executed on BWA, to find period will too many queries in parallel and look for a workaround if memory/performance is impacted by this e.g., remove parallelization setting of some queries. It also provides a benchmark, we know what can be achieved without degradation. | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_RSDDSTATS | BW_5MIN | 5 MI |
| BW_SUBQ_ALLTIM | nonSQL-Total time spent on subqueries (BWA or HANA) | Cumulated time spent on BWA of all subqueries. Also to know if we are reaching some limit. | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_RSDDSTATS | BW_5MIN | 5 MI |
| BW_SUBQ_SQAR | nonSQL-Average runtime of small subqueries (BWA or HANA) | When using op mode 2 in BWA, queries are split into a subquery, one per cube. Per definition, Small subqueries are scanning less than 10 million rows and returning less than 10.000 rows. Those should run for 1 sec on BWA. This indicator calculates the average BWA runtime of small queries. | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_RSDDSTATS | BW_5MIN | 5 MI |
| BW_SUBQ_SQLO | nonSQL-No of small subqueries long running (e.g.,>10SEC) e.g., BWA | See above the definition of small subqueries. If the average is slow, to appreciate the impact, this KPI provides the number of subqueries running for more than 10 sec. If there are 5 or 10.000 subqueries running too slow, the impact on the business is not the same. | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_RSDDSTATS | BW_5MIN | 5 MI |
| BW_SUBQ_SQNO | nonSQL-No of small subqueries (BWA or HANA) | This KPI is the number of small subqueries (nonSQL). | BW | SYS | any server | Remote system | /DVD/MON_BW_CL_COL_RSDDSTATS | BW_5MIN | 5 MI |
| BWA_AGE_NEWSID | BWA : Age of oldest SID not processed | If Master data SIDs are not updated in BWA, entries will remain in the table rsddtrexnewsid. Table /DVD/MON_NEWSID contains the oldest SID and timestamp of rsddtrexnewsid. This KPI is the age of the oldest SID not updated in BWA. Check if the attribute change run has failed or long running. Check BWA alerts for the Master data index has been corrupted. Check Job BI_BIA_NEWMD_INDEX. Check application log : TCode SLG1, Filter : Object = "RSDDTREX" Subobject = "TAGGRFILL" Check that object is still active (table rsddbobjdir or transaction rsddb). We checked for the above in SLG1. Everything is fine. Hence, we are closing the ticket. Please find the added attachment. | BWA | SYS | any server | Remote system | /DVD/MON_BWA_CL_COL_BWASID | BWA_1HOUR | 1 HO |
| BWA_ALERT_RED_NO | BWA : Number of red alerts | This is a count of the number of red alerts in TREXADMIN. The details of the alert can be seen in the ‘Details’ tab, BWA Alerts. | BWA | SYS | any server | Remote system | /DVD/MON_BWA_CL_COL_BWA | BWA_1HOUR | 1 HO |
| BWA_CPU_USED | BWA : CPU load on the most loaded blade | This KPI is the max CPU load (of all blades) calculated by TREXADMIN, FM TREX_EXT_LOAD_HISTORY since the last execution. | BWA | SYS | any server | Remote system | /DVD/MON_BWA_CL_COL_BWA | BWA_5MIN | 5 MI |
| BWA_INDX_INA_DUR | BWA : Missing or inactive BWA cube index - duration | When a cube index is created, the list of indexes that have been active once (table /DVD/MON_BWAINDX) is automatically updated on the satellite system at the next run of the agent. At each execution of the agent, CanaryCode checks that all indexes exist and have status ACT. If an index is missing, CanaryCode flags the index as missing, calculates it since when it’s missing, and updates the list that is visible from tab ‘Details’, "BWA inactive indexes". This KPI is the max missing period for all cubes. | BWA | SYS | any server | Remote system | /DVD/MON_BWA_CL_COL_BWA | BWA_1HOUR | 1 HO |
| BWA_INDX_INA_NO | BWA : Missing or inactive BWA cube index - number | When a new BWA cube index is created, it is added automatically in table /DVD/MON_BWAINDX. An index can be missing for some time (for example cube index is dropped and recreated after selective deletion), in case they are missing for too long, we want to be alerted. At each execution of the collector, we check that all indexes contained in the table /DVD/MON_BWAINDX have status ACT. This KPI counts the number of indexes missing for more than an authorized period value. The authorized period value can be maintained for each cube in /DVD/MON_BWAINDX, by default it’s 90 minutes. If an index is deleted and will not be rebuilt, it should be removed from /DVD/MON_BWAINDX to avoid the alert. The list of the missing indexes is visible in the tab ‘Details’, "BWA inactive indexes", column "alert" contains value ‘X’ if the index has been missing for more than the authorized period value. | BWA | SYS | any server | Remote system | /DVD/MON_BWA_CL_COL_BWA | BWA_1HOUR | 1 HO |
| BWA_IS_PING | BWA : IS Ping time | This KPI is the "ping" time calculated by TREXADMIN, FM TREX_EXT_LOAD_HISTORY field IS_PING_TIME, between the nameserver and the indexserver. The nameserver contacts each indexserver to check if the connection works fine. This KPI is the max value (of all blades) captured since the last execution. | BWA | SYS | any server | Remote system | /DVD/MON_BWA_CL_COL_BWA | BWA_5MIN | 5 MI |
| BWA_SERVICE_INAC | BWA : No of services inactive | At each execution of the agent, we check the status of each service reported by TREXADMIN. This KPI counts the number of services where the status is not green. Sometimes the status is undefined (not green, not red) but it’s visible only from time to time. If CanaryCode reports that some services are inactive, filter status on active NE green and refresh regularly to see the status on TREX. You can also see the service reported as inactive in the ‘Details’ tab, "BWA service restarted or inactive". | BWA | SYS | any server | Remote system | /DVD/MON_BWA_CL_COL_BWA | BWA_5MIN | 5 MI |
| BWA_SERVICE_REST | BWA : No of services restarted | At each execution of the agent, we check the "Start time" of each service in TREXADMIN. This KPI is the number of services restarted since the last execution. When the memory consumption of a blade exceeds the limit, the blade might restart by itself. When a blade restarts all jobs and queries are killed, so it has a major impact on users. With this indicator, you can be alerted if a blade/service restarts to find the root cause of the restart. | BWA | SYS | any server | Remote system | /DVD/MON_BWA_CL_COL_BWA | BWA_5MIN | 5 MI |
| BWA_THRD_NO | BWA : Number of running threads for more than 10 sec | If a blade is overloaded, the threads can slow down and the number of long running threads will increase. This indicator can help you to detect when a blade is slowing down. Be aware that during cube indexing, index merging, it is normal to have long running threads. | BWA | SYS | any server | Remote system | /DVD/MON_BWA_CL_COL_BWA | BWA_5MIN | 5 MI |
| BWA_THRD_TIME | BWA : Runtime of longest thread | This is the runtime of the longest running thread captured in TREXADMIN. This KPI can inform when there is a lock, a zombie thread. If it does not cause any lock, an OSS message should be open to investigating. If a rollup or changerun or master data SID update is locked and must be solved immediately, then a restart of the index server and RFC server is required. See doc on alerts. | BWA | SYS | any server | Remote system | /DVD/MON_BWA_CL_COL_BWA | BWA_1HOUR | 1 HO |
| BWA_TTLMEM | BWA : Memory on the most loaded blade (as a percentage of total) | The speed of a BWA system is limited by the speed of the slowest blade. If you have 15 blades, it’s important that you have the memory available on all the blades. And instead of recording individually the memory of each blade, we can record only a KPI for the worth-performing blade. The memory of blade 1,2 and 3 are recorded as benchmarks. The details for all the blades are saved in the "Detail tab".This KPI is the max memory used of all blades calculated by TREXADMIN, FM TREX_EXT_LOAD_HISTORY since the last execution. | BWA | SYS | any server | Remote system | /DVD/MON_BWA_CL_COL_BWA | BWA_5MIN | 5 MI |
| BWA_TTLMEM_BL01 | BWA : Memory on Blade 1 | The most important KPI on memory is "BWA_TTLMEM BWA : Memory on the most loaded blade (as a percentage of total)". As it’s the most loaded blade, it will show different blade at different time. To see the trend on one blade, those KPI, memory on blade 1,2, and 3 are delivered. | BWA | SYS | any server | Remote system | /DVD/MON_BWA_CL_COL_BWA | BWA_5MIN | 5 MI |
| BWA_TTLMEM_BL02 | BWA : Memory on Blade 2 | The most important KPI on memory is "BWA_TTLMEM BWA : Memory on the most loaded blade (as a percentage of total)". As it’s the most loaded blade, it will show different blade at different time. To see the trend on one blade, those KPI, memory on blade 1,2, and 3 are delivered. | BWA | SYS | any server | Remote system | /DVD/MON_BWA_CL_COL_BWA | BWA_5MIN | 5 MI |
| BWA_TTLMEM_BL03 | BWA : Memory on Blade 3 | The most important KPI on memory is "BWA_TTLMEM BWA : Memory on the most loaded blade (as a percentage of total)". As it’s the most loaded blade, it will show different blade at different time. To see the trend on one blade, those KPI, memory on blade 1,2, and 3 are delivered. | BWA | SYS | any server | Remote system | /DVD/MON_BWA_CL_COL_BWA | BWA_5MIN | 5 MI |
| BWA_UNLOADS | BWA : Unloads (max per blade) | This is the highest unload per blade reported by TREXADMIN (FM 'TREX_EXT_LOAD_HISTORY from the field of a structure 'TREX_LOAD_UNLOAD_COUNT') in the last 5 minutes. When the value KPI increases rapidly, it could indicate problems with the memory or BWA overload in the worst case. The reason for this problem could be low memory or too big indexes. The count of unloads couldn't be bigger than 200 unloads in the last 24 hours. SAP Note 1796356 could be helpful for in-depth analysis. | BWA | SYS | any server | Remote system | /DVD/MON_BWA_CL_COL_BWA | BWA_1HOUR | 1 HO |
| CF_THRESHOLD | KPI with calculation function relative to the threshold of KPI | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CA_CL_COL_CALC | |||
| CPU_IDLE | CPU true idle | Times in which the CPU had no task to perform or was waiting for an input/output. | OS | SER | any server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_1MIN | 1 MI |
| CPU_LOAD1 | CPU - Average processes waiting (1 min) | The Average CPU Load (1, 5, and 15 minute averages) is the average number of processes that are ready for execution, but which must wait for the CPU. In SAP, you can see this indicator with OS07. If the average number of processes waiting is higher than the number of available CPUs, this indicates that the CPU is reducing the overall performance of the system. "CPU load %" is the CPU load divided by the number of CPUs available on the hardware. Values are captured for the database and for all application servers. The chart displays only the CPU of the database. There are many AS and CPU of AS is usually not an issue. Bad exec plan can increase dramatically CPU load of the DB. | OS | SER | any server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_1MIN | 1 MI |
| CPU_LOAD1_P | CPU - Average processes waiting (15 min) | The Average CPU Load (1, 5, and 15-minute averages) is the average number of processes that are ready for execution, but which must wait for the CPU. In SAP, you can see this indicator with OS07. If the average number of processes waiting is higher than the number of available CPUs, this indicates that the CPU is reducing the overall performance of the system. "CPU load %" is the CPU load divided by the number of CPUs available on the hardware. Values are captured for the database and for all application servers. The chart displays only the CPU of the database. There are many AS and CPU of AS is usually not an issue. But a bad exec plan can increase dramatically CPU load of the DB. | OS | SER | any server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_1MIN | 1 MI |
| CPU_LOAD15 | CPU - Average processes waiting (15 min) per CPU | The Average CPU Load (1, 5, and 15-minute averages) is the average number of processes that are ready for execution, but which must wait for the CPU. In SAP, you can see this indicator with OS07. If the average number of processes waiting is higher than the number of available CPUs, this indicates the CPU is reducing the overall performance of the system. "CPU load %" is the CPU load divided by the number of CPUs available on the hardware. Values are captured for the database and for all application servers. The chart displays only the CPU of the database. There are many AS and CPU of AS is usually not an issue. But bad exec plan can increase dramatically CPU load of the DB. | OS | SER | any server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | 15 MI | |
| CPU_LOAD15_P | CPU - Average processes waiting (1 min) per CPU | The Average CPU Load (1, 5, and 15 minute averages) is the average number of processes that are ready for execution, but which must wait for the CPU. In SAP, you can see this indicator with OS07. If the average number of processes waiting is higher than the number of available CPUs, this indicates the CPU is reducing the overall performance of the system. "CPU load %" is the CPU load divided by the number of CPUs available on the hardware. Values are captured for the database and for all application servers. The chart displays only the CPU of the database. There are many AS and CPU of AS is usually not an issue. | OS | SER | any server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | 15 MI | |
| CPU_LOAD5 | CPU - Average processes waiting (5 min) | The Average CPU Load (1, 5, and 15-minute averages) is the average number of processes that are ready for execution, but which must wait for the CPU. In SAP, you can see this indicator with OS07. If the average number of processes waiting is higher than the number of available CPUs, this indicates that the CPU is reducing the overall performance of the system. "CPU load %" is the CPU load divided by the number of CPUs available on the hardware. Values are captured for the database and for all application servers. The chart displays only the CPU of the database. There are many AS and CPU of AS is usually not an issue. But a bad exec plan can increase dramatically CPU load of the DB. | OS | SER | any server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_5MIN | 5 MI |
| CPU_LOAD5_P | CPU - Average processes waiting (5 min) per CPU | The Average CPU Load (1, 5, and 15-minute averages) is the average number of processes that are ready for execution, but which must wait for the CPU. In SAP, you can see this indicator with OS07. If the average number of processes waiting is higher than the number of available CPUs, this indicates that the CPU is reducing the overall performance of the system."CPU load %" is the CPU load divided by the number of CPUs available on the hardware. Values are captured for the database and for all application servers. The chart displays only the CPU of the database. There are many AS and CPU of AS is usually not an issue. But a bad exec plan can increase dramatically CPU load of the DB. | OS | SER | any server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_5MIN | 5 MI |
| CPU_LOAD5_PMAX | CPU - Maximum average processes waiting (5 min) per CPU | CPU_LOAD5_PMAX is the maximum value of CPU load in 5 minutes across all servers. The Average CPU Load (1, 5, and 15-minute averages) is the average number of processes that are ready for execution, but which must wait for the CPU. In SAP, you can see this indicator with OS07. If the average number of processes waiting is higher than the number of available CPUs, this indicates that the CPU is reducing the overall performance of the system."CPU load %" is the CPU load divided by the number of CPUs available on the hardware. Values are captured for the database and for all application servers. The chart displays only the CPU of the database. There are many AS and CPU of AS is usually not an issue. But a bad exec plan can increase dramatically CPU load of the DB. | OS | SYS | only application server | Central system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_5MIN | 5 MI |
| CPU_NBR | Number of CPU's | The number of CPUs is displayed by this KPI. | OS | SER | any server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_1DAY | 1 DA |
| CPU_SYS | CPU used by the system | Percentage usage of CPU by the user is displayed by this KPI. | OS | SER | any server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_1MIN | 1 MI |
| CPU_USER | CPU used by the user | CPU used by the user is measured by KPI called CPU_USER and a suitable transaction for checking is ST06. | OS | SER | any server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_1MIN | 1 MI |
| CPU_WAIT | CPU IO wait | I/O wait "utilization" accrues when the CPU would be able to do some work, but all processes on the CPU are waiting for I/O responses. In SAP, you can see this indicator with OS07. Values are captured for the database and for all application servers. The chart displays only the worst value (usually IO wait of the database, IO wait on AS is usually zero). | OS | SER | any server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_1MIN | 1 MI |
| CPU_WAIT_MAX | CPU IO wait (max. in all servers) | I/O wait "utilization" accrues when the CPU would be able to do some work, but all processes on the CPU are waiting for I/O responses. The value is calculated by CCMS, see transaction ST06. This KPI is the max value of the "IO wait" for all monitored servers for this SID. | OS | SYS | only application server | Central system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_1MIN | 1 MI |
| CTS_AGE_OLDESTRQ | CTS - Age of the oldest request in the queue | Age of the oldest transport request in the queue. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_CTS | DEF_1DAY | 1 DA |
| CTS_COUNT_REQNM | CTS - Number of requests not moving in the queue | This KPI is a number of transport requests in the import queue which was not imported (their state did not change) since the last snapshot (monitored run). Too many not imported transports could indicate a problem with import queue or with automatic imports. If the value of this KPI decreases and indirectly correlates with some incident – it means that on the system were imported transports that affected the given problem. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_CTS | DEF_1HOUR | 1 HO |
| CTS_RC0008 | CTS - Number of transport in RC8 | Number of transport requests with RC8. | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_CTS | DEF_1DAY | 1 DA |
| CTS_RC0008A | CTS - Number of transport in RC8 and above | Number of transport requests with RC8 and above. | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_CTS | DEF_1DAY | 1 DA |
| CTS_RC0012A | CTS - Number of transport in RC12 and above | Number of transport requests with RC12 and above. | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_CTS | DEF_1DAY | 1 DA |
| DB_CPU_LOAD5_P | DB CPU Load (avg 5 min) per CPU | The value is calculated by CCMS, see transaction ST06N, select the database. This KPI is the "cpu load avg 5 min" divided by the number of CPU. | DB | SYS | any server | Remote system | /DVD/MON_CL_COL_DB_CPULOAD | DEF_5MIN | 5 MI |
| DB_CRIT_TAB_SP_P | Free space on the most critical data file (table space) | KPI displays the percentage of a free space that has the most critical data file of database available. Most critical data file (table space) is chosen by size, so the biggest data file (table space) is a critical file. For files that do not have a maximum size set, the size of the logical device the file resides upon is used. Percentage is then calculated from this size. | DB | SYS | any server | Remote system | /DVD/MON_CL_COL_DB | DEF_5MIN | 5 MI |
| DB_FREE | Free size of the database | KPI displays the percentage of a free space that has the most critical data file of database available. Most critical data file (table space) is chosen by size, so the biggest data file (table space) is a critical file. For files that do not have a maximum size set, the size of the logical device the file resides upon is used. Percentage is then calculated from this size. | DB | SYS | any server | Remote system | /DVD/MON_CL_COL_DB | DEF_1DAY | 1 DA |
| DB_INDEX_NUM | Total number of indexes | This KPI contains information about the total number of indexes. Index is a copy of a database table having few numbers of fields. This copy is always in sorted form. As we know, sorted data would always have speed access from a database table. Hence, we use an index for the table while reading the database records. Index also contains a pointer pointing towards the actual database table so that it can access fields that are not contained in the Index. There are two kinds of an index for a database table: Primary Index, Secondary Index | DB | SYS | any server | Remote system | /DVD/MON_CL_COL_DB | DEF_1DAY | 1 DA |
| DB_INDEX_SIZE | Total size of indexes | This KPI describes, how total size can acquire indexes. Transaction to find out the total size of indexes is : DBACOCKPIT -> SPACE -> SEGMENTS -> OVERVIEW -> TOP SIZES (and then filter on column type). | DB | SYS | any server | Remote system | /DVD/MON_CL_COL_DB | DEF_1DAY | 1 DA |
| DB_SIZE | Size of database | Database size contains : 1. Number of records in tables 2. Table columns and their sizes 3. Indexes in the model 4. Table spaces in the model 5. DBMS and its storage options All these factors affect the size of a database and the total summary of these elements is processed by this KPI. | DB | SYS | any server | Remote system | /DVD/MON_CL_COL_DB | DEF_1DAY | 1 DA |
| DB_TAB_NUM | Total numbers of tables | Each database has several tables. Table is one of the basic database objects, which main role is storing data into the memory space of the relational database. This KPI measures how many tables contain the database. Information about the total number of tables contains the transaction DB02. | DB | SYS | any server | Remote system | /DVD/MON_CL_COL_DB | DEF_1DAY | 1 DA |
| DB_TAB_SIZE | Total size of tables | The current table sizes are determined by a report and saved in a database table which forms the history of table sizes and table growth. Displaying the table size: 1. Open the Database Assistant 2. Choose Statistics --> Table Size This KPI displays the actual value of the size of all tables. | DB | SYS | any server | Remote system | /DVD/MON_CL_COL_DB | DEF_1DAY | 1 DA |
| DB_TRIGGER_CNT_ALL | Number of all DB Triggers | KPI value represents the number of all available DB triggers on the system. | DB | SYS | any server | Remote system | /DVD/MON_CL_COL_DB_TRIGGERS | DEF_1HOUR | 1 HO |
| DB_TRIGGER_CNT_INVALID | Number of Invalid DB Triggers | KPI value represents the total number of all invalid DB triggers on the system. | DB | SYS | any server | Remote system | /DVD/MON_CL_COL_DB_TRIGGERS | DEF_1HOUR | 1 HO |
| DB_TRIGGER_CNT_VALID | Number of valid DB Triggers | KPI value represents the total number of all valid DB triggers on the system. | DB | SYS | any server | Remote system | /DVD/MON_CL_COL_DB_TRIGGERS | DEF_1HOUR | 1 HO |
| DB_USED | Used size of the database | KPI of used DB size in MB. This KPI is calculated as total DB size minus DB free space available. Threshold values depend on the DB system used and on company needs. | DB | SYS | any server | Remote system | /DVD/MON_CL_COL_DB | DEF_1DAY | 1 DA |
| DELAY_LAST_RUN | Delay since last successful run | Measures the last successful run of the collector job. If some jobs are hanging or running in a never-ending loop, then the next collector will not be started. This KPI displays the time of the last successful completion of the collector job. | SAPSYS | SYS | any server | Central system | DEF_1MIN | 1 MI | |
| DEQ_ALL_REQ_CNT | Number of releases of all locks of an LUW | A database LUW is an inseparable sequence of database operations that ends with a database commit. The database LUW is either fully executed by the database system or not at all. Once a database LUW has been successfully executed, the database will be in a consistent state. If an error occurs within a database LUW, all of the database changes since the beginning of the database LUW are reversed. If you execute SAP transactions to change database objects, these objects get locked beforehand to prevent being accessed by other users or transactions, and they get released after database commit or database rollback - this KPI counts the number of these releases. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| DEQ_ERROR_CNT | Number of errors that occurred when releasing locks | The database system automatically sets database locks when it receives change statements (INSERT, UPDATE, MODIFY, DELETE) from a program. Database locks are physical locks on the database entries affected by these statements. You can only set a lock for an existing database entry since the lock mechanism uses a lock flag in the entry. These flags are automatically deleted in each database commit. Database locks are therefore never available longer than for only one database LUW. It means that in ABAP application programming, database locks can no longer exist than the duration of one dialog step. If there are some errors when releasing locks, this KPI counts the number of these errors. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| DEQ_REQUEST_CNT | Number of release requests (DEQUEUE) | A lock object definition contains the database tables and their key fields on the basis of which you want to set a lock. When you create a lock object, the system automatically generates two function modules with the names ENQUEUE_Name and DEQUEUE_Name. You can then set and release SAP locks in your ABAP program by calling these function modules in a CALL FUNCTION statement - this KPI counts the number of dequeue release requests. You can see lock statistics in SM12 Extras -> Statistics transaction. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| DISK_AVG_WAIT | Average disk wait (server) | This KPI is the average disk wait on the server. | OS | SER | any server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_5MIN | 5 MI |
| DISK_RESPONS_SYS | Disk response time (server) | This KPI is the average disk response time on all servers. | OS | SYS | only application server | Central system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_5MIN | 5 MI |
| DISK_RESPONSE | Average disk response time (all servers) | This KPI is disk response time on the server. | OS | SER | any server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_5MIN | 5 MI |
| DISK_UTIL | Disk utilization (server) | This KPI is disk utilization on the server. | OS | SER | any server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_5MIN | 5 MI |
| DISK_UTIL_SYS | Average disk utilization (all servers) | This KPI is disk utilization on all servers. | OS | SYS | only application server | Central system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_5MIN | 5 MI |
| DISK_WAIT_SYS | Average disk wait time (all servers) | This KPI is the average disk wait time on all servers. | OS | SYS | only application server | Central system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_5MIN | 5 MI |
| DUMP_AUTH_ERR | Number of dumps on authorization failure | This KPI represents a count of the dump which occurred by missing authorization | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_GET_DUMP | DEF_1HOUR | 1 HO |
| DUMP_DBIF | Number of dumps on SQL operations | This KPI represents a count of the dump which occurred by SQL operations. | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_GET_DUMP | DEF_1HOUR | 1 HO |
| DUMP_NBR | Number of dumps on a server | Number of dumps for all application servers as per ST22 from last monitoring time. | SAPSYS | SER | only application server | Remote system | /DVD/MON_CL_COL_GET_DUMP | DEF_1DAY | 1 DA |
| DUMP_NBR_SUM | Number of dumps (all servers) | Number of dumps on the SID since the last run of CanaryCode. | SAPSYS | SYS | only application server | Central system | /DVD/MON_CL_COL_GET_DUMP | DEF_1DAY | 1 DA |
| DUMP_SYNTAX_ERR | Number of dumps with the syntax error | This KPI represents a count of the dump which occurred by syntax errors. | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_GET_DUMP | DEF_1DAY | 1 DA |
| EM_USED_P | Extended memory used | Extended Memory (EM) contains objects associated with individual users and their open (running) transactions - transaction data such as variables, lists, and internal tables. If the work process requires still more space after using up all available Extended Memory and Roll Area, the system is forced to allocate local Heap Memory. This KPI is the amount of Extended Memory used. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_BUFF | DEF_5MIN | 5 MI |
| ENQ_ARG_MAX_CNT | Max. num. of diff. lock arguments that the LT can contain | The lock argument of a table in the lock object consists of the key fields of the table. The lock argument fields of a lock object are used as input parameters in the function modules for setting and removing locks generated from the lock object definition. When these function modules are called, the table rows to be locked or unlocked are specified by defining certain values in these fields. These values can also be generic. The lock argument fields define which subset of the table rows must be locked. This KPI is the maximal number of different lock arguments that can the Landscape Transformation (LT) possibly contains. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| ENQ_ARG_MAX_LVL | Max. num. of diff. lock arg. stored simultaneously in the LT | The lock argument of a table in the lock object consists of the key fields of the table. The lock argument fields of a lock object are used as input parameters in the function modules for setting and removing locks generated from the lock object definition. When these function modules are called, the table rows to be locked or unlocked are specified by defining certain values in these fields. These values can also be generic. The lock argument fields define which subset of the table rows must be locked. This KPI is the maximal number of different lock arguments which are simultaneously stored in the Landscape Transformation (LT). | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| ENQ_ARG_NOW_LVL | Current number of different lock arguments in the lock table | The lock argument of a table in the lock object consists of the key fields of the table. The lock argument fields of a lock object are used as input parameters in the function modules for setting and removing locks generated from the lock object definition. Lock table is a table in the main memory of the enqueue server that records the current locks in the system. For each elementary lock, the table specifies the owner, lock mode, name, and the fields in the locked table. The lock table is used to manage locks. Every time the enqueue server receives a lock request, the system checks the lock table to determine whether the request collides with an existing lock. If this is the case, the request is rejected. Otherwise, the new lock is written to the lock table. This KPI counts the number of all different lock arguments stored in this lock table. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| ENQ_BACKUP_REQ | Number of update calls for which locks were forwarded | This KPI counts the number of update calls for which locks were forwarded. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| ENQ_CLEAN_REQ | Number of releases of all locks of an application server | Physical lock mechanisms in the database system are insufficient for the requirements of an ABAP transaction. The locks must remain set for the duration of a whole SAP LUW, that is, over several dialog steps. They must also be capable of being handled by different work processes and even different application servers. This KPI counts the number of all releases of all locks of a selected application server. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| ENQ_COMPR_REQ | Compress Requests | SAPSYS | SYS | any serverr | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI | |
| ENQ_ENTR_MAX_CNT | Max. num. of elementary locks that the LT can contain | Lock table is a table in the main memory of the enqueue server that records the current locks in the system. For each elementary lock, the table specifies the owner, lock mode, name, and the fields in the locked table. This KPI is the maximal number of elementary locks that can the Landscape Transformation (LT) possibly contains. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| ENQ_ENTR_MAX_LVL | Max. num. of elementary locks stored simultaneously in the LT | Lock table is a table in the main memory of the enqueue server that records the current locks in the system. For each elementary lock, the table specifies the owner, lock mode, name, and the fields in the locked table. This KPI is the maximal number of elementary locks stored simultaneously in the Landscape Transformation (LT). | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| ENQ_ENTR_NOW_LVL | Current number of elementary locks in the lock table | Lock table is a table in the main memory of the enqueue server that records the current locks in the system. For each elementary lock, the table specifies the owner, lock mode, name, and the fields in the locked table. This KPI is the current number of elementary locks stored in the lock table. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| ENQ_ENTR_P | Usage of SAP lock table | The lock table is used to manage locks. Every time the enqueue server receives a lock request, the system checks the lock table to determine whether the request collides with an existing lock (see Lock Collisions). If this is the case, the request is rejected. Otherwise, the new lock is written to the lock table. This KPI is a percentage of lock table usage. | SAPSYS | SYS | any server | Central system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| ENQ_ERROR_CNT | Number of errors that occurred during lock requests | This KPI is a number of errors that occurred during lock requests. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| ENQ_FILE_WRITE | Number of write accesses to file | This KPI is the number of write accesses to file. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| ENQ_FILE_WRT_BCK | Number of write accesses to the backup file | This KPI is the number of write accesses to the backup file. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| ENQ_OWN_MAX_CNT | Max. num. of lock owner IDs that can be stored in the LT | Lock owner is a person who holds a lock. A lock can have one or two owners. This KPI is the maximal number of lock owner IDs that can be possibly stored in the Landscape Transformation (LT). | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| ENQ_OWN_MAX_LVL | Max. num. of lock owners stored simultaneously in the LT | Lock owner is a person who holds a lock. A lock can have one or two owners. This KPI is the maximal number of lock owners that are simultaneously stored in the Landscape Transformation (LT). | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| ENQ_OWN_NOW_LVL | Current number of lock owners in the lock table | Lock owner is a person who holds a lock. A lock can have one or two owners. To find out which user is currently holding a lock, use function module ENQUEUE_.... This KPI is the current number of all lock owners stored in the lock table. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| ENQ_REPORT_REQ | Number of operations for reading the lock table | This KPI is the number of operations for reading the lock table. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| ENQ_REQ_REJ_CNT | Number of lock requests | This KPI is the number of rejected lock requests. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| ENQ_REQ_REJ_CNTD | Number of lock requests per minute since the last run | This KPI is the number of rejected lock requests per minute since the last run. | SAPSYS | SYS | any server | Central system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| ENQ_REQUEST_CNT | Number of rejected lock requests | Sm12 – statistics give the current value of ENQ processed. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| ENQ_REQUEST_CNTD | Number of rejected lock requests per minute since the last run | This KPI is the delta between the value of ENQ processed at the last snapshot and the current value, divided by the number of minutes since the last snapshot to calculate the number of ENQ processed per minute. If we have a high number of WP in SAPLSENA and the number of ENQ per minute is high, the issue is the application is raising too many ENQ. Solution is to find the root cause of the high number of ENQ, which can be too many packets (e.g., too many small packets) or too many requests in rsiccont. It is useful to monitor this number on parallel processes. | SAPSYS | SYS | any server | Central system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| ENQ_TOT_SER_TIME | Total time spent in the critical path of the LT for lock op. | The enqueue server (also known as the lock server) is the SAP system component that manages the lock table. There is only one enqueue server in a distributed SAP system. The enqueue server receives a lock request and checks the lock table to determine whether the lock request collides with an existing lock. If it does, the enqueue server rejects it. If it does not collide, the enqueue server sets the lock and makes the entry in the lock table. This KPI is the total time spent in the enqueue server. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| ENQ_TOTAL_TIME | Total wait time of par. proc. before entering the critical path | This KPI counts the total time spent in the critical path of the Landscape Transformation for lock operations. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| ENQ_TOTAL_WAIT | Total time spent in the enqueue server | This KPI counts the total wait time of parallel processing before entering the critical path. Waiting time for all work processes for accessing lock table. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| ENQ_UPD_MAX_CNT | Max. num. of open update req. with locks occurred so far | This KPI is a maximal number of accumulated update requests. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| ENQ_UPD_NOW_LVL | Current number of open update requests with locks | This KPI is the current number of outstanding update requests. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| ENQ_VERIFY_REQ | Verify Requests | Verify requests | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_ENQUEUE_STAT | DEF_5MIN | 5 MI |
| FS_ROOT_FREE | Free space monitoring on the root partition | Free space monitoring on root partition as % of the whole space. | OS | SER | any server | Remote system | /DVD/MON_CL_COL_SYS_FS | ||
| GLUE_ERR_EXTR_NU M | Number of Glue extraction processes that ended up with an error | In Glue, every extraction process can have various statuses. Some are desired and some are not. Undesired means that they did not end up successfully. There are 2 undesired statuses: "E" (Ended with error) and "F" (Failure, short-dump). This KPI informs about the number of extraction processes that have an undesired status and provides details about them. | GLUE | SYS | any server | Remote system | /DVD/MON_GLU_CL_COL_EXTRACTION | ||
| GRC_AOC_BC_ALL | Number of SAP_BC roles having full auth. on org. level | GRC | SYS | only application server | Remote system | /DVD/MON_GRC_CL_COL_AUTH_OC | GRC_1DAY | 1 DA | |
| GRC_AOC_SEC_ALL | Number of SAP_SEC_ roles having full auth. on org. level | GRC | SYS | only application server | Remote system | /DVD/MON_GRC_CL_COL_AUTH_OC | GRC_1DAY | 1 DA | |
| GRC_AOC_ZCOM_ALL | Number of X,Y,Z* roles having full auth. on company code | GRC | SYS | only application server | Remote system | /DVD/MON_GRC_CL_COL_AUTH_OC | GRC_1DAY | 1 DA | |
| GRC_REF_USR_CNT | Number of used reference users | GRC | SYS | any server | Remote system | /DVD/MON_GRC_CL_COL_REF_USERS | |||
| GRC_SEC_NOTE_CNT | Number of not implemented security notes | GRC | SYS | any server | Remote system | /DVD/MON_GRC_CL_COL_SEC_NOTES | |||
| GRC_AUTH_ALL | Number of users with fill authorization (SAP_ALL, SAP_NEW) | SAPSYS | SYS | only application server | Remote system | /DVD/MON_GRC_CL_COL_USR_AUTH | GRC_1DAY | 1 DA | |
| GRC_AUTH_ALL_O_N | Number of NEW users with full authorization (SAP_ALL,SAP_NEW) | GRC | SYS | only application server | Remote system | /DVD/MON_GRC_CL_COL_USR_AUTH | |||
| GRC_PROF_PARAM | Num. of profile parameters with unexpected values | Collector checks values of profile parameters and compares them with values in the collector’s input table. This procedure is performed for each server. KPI is the number of parameters that have different values from the values specified in the input table. | GRC | SYS | only application server | Remote system | /DVD/MON_GRC_CL_COL_PARAM | DEF_1DAY | 1 DA |
| HDB_BCK_DELAY_D | Time since last successful DATA backup | A backup, or the process of backing up, refers to the copying and archiving of data so it may be used to restore the original after a data loss event. Data backups contain the current payload of the data volumes (data and undo information). This KPI counts time since the last successful DATA backup. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_BCK | HDB_5MIN | 5 MI |
| HDB_BCK_DELAY_L | Time since last successful LOG backup | By default, automatic log backups are enabled in SAP HANA. Backup log is a feature of backup applications that records the events that occur during a backup process. This KPI counts time since the last successful LOG backup. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_BCK | HDB_5MIN | 5 MI |
| HDB_BCK_FAILED | Number of failed backups | Media failure, human error, and hardware failure are among the most common reasons backups fail. When the backup is performed with some errors, a number of failed backups is recorded by this KPI. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_BCK | HDB_5MIN | 5 MI |
| HDB_CPU_HOST | CPU utilization per host (avg 5 mins) | The CPU utilization will always sum up to 100%. User utilization should not exceed a value of 50 to 60%. System utilization should be below 20% and Idle time should be above 20%. The max CPU utilization is the utilization of CPU the most of the possible. Maximal CPU utilization per host displays avg utilization counted every 5 minutes. | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_CPU | HDB_5MIN | 5 MI |
| HDB_CPU_MAX_P | Max CPU utilization on all hosts (avg 5 mins) | The CPU utilization will always sum up to 100%. User utilization should not exceed a value of 50 to 60%. System utilization should be below 20% and Idle time should be above 20%. The max CPU utilization is the utilization of CPU the most of the possible. Maximal CPU utilization on all hosts is measured by this KPI. This KPI displays avg utilization counted every 5 minutes. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_CPU | HDB_5MIN | 5 MI |
| HDB_CPU_SYS_P | CPU utilization by the system (avg 5 mins) | System utilization of CPU should be below 20%. System CPU time is the time spent running a code in the operating system kernel on behalf of your program. When the value of system utilization rises up above 20%, it can signalize some failures. This KPI displays utilization of CPU by system counted every 5 minutes. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_CPU | HDB_5MIN | 5 MI |
| HDB_CPU_SYS_SER | CPU utilization by the system per host (avg 5 mins) | System utilization of CPU should be below 20%. System CPU time is the time spent running a code in the operating system kernel on behalf of your program. When the value of system utilization rises up above 20%, it can signalize some failures. CPU utilization by the system per server is documented by KPI with the name HDB_CPU_SYS_SER. | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_CPU | HDB_5MIN | 5 MI |
| HDB_CPU_USR_P | CPU utilization by users (avg 5 mins) | User utilization should not exceed a value of 50 to 60%. User CPU time is the time spent on the processor running a program's code (or code in libraries). This KPI displays a situation when the CPU is utilized by the user. In this situation, avg utilization is counted every 5 minutes. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_CPU | HDB_5MIN | 5 MI |
| HDB_CPU_USR_SER | CPU utilization by users per host (avg 5 mins) | User utilization should not exceed a value of 50 to 60%. User CPU time is time spent on the processor running your program's code (or code in libraries). When the CPU is utilized by users per server, this KPI counted utilization every 5 minutes. | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_CPU | HDB_5MIN | 5 MI |
| HDB_CPU_UTIL_P | Total CPU utilization (avg 5 mins) | The CPU utilization will always sum up to 100%. User utilization should not exceed a value of 50 to 60%. System utilization should be below 20% and Idle time should be above 20%. When CPU utilization is at its maximum, this progress tries to record this KPI. The value of utilization is measured in 5 minutes intervals. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_CPU | HDB_5MIN | 5 MI |
| HDB_CPU_WIO_P | CPU utilization in I/O waits (avg 5 mins) | I/O wait is the total time that working processes are blocked, waiting for the I/O operation to complete. An I/O operation is a request to retrieve or write data to the storage. The total time that it takes to complete all I/O operations is I/O operation time. I/O wait happens due to heavy load on the system. This KPI show CPU utilization in I/O waits. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_CPU | HDB_5MIN | 5 MI |
| HDB_CPU_WIO_SER | CPU utilization in I/O waits per host (avg 5 mins) | I/O wait is the total time that working processes are blocked, waiting for the I/O operation to complete. An I/O operation is a request to retrieve or write data to the storage. The total time that it takes to complete all I/O operations is I/O operation time. I/O wait happens due to heavy load on the system. This KPI measures CPU utilization in I/O waits per server. | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_CPU | HDB_5MIN | 5 MI |
| HDB_CS_DELRATIO | Delta memory / Total memory ratio | Percentage of delta memory versus total memory used. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_TAB | HDB_5MIN | 5 MI |
| HDB_CS_DELTASIZE | Size of column tables in delta memory | Total size of column table data in delta memory. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_TAB | HDB_5MIN | 5 MI |
| HDB_CS_ESTIMSIZE | Size of column tables estimated | Estimated size of column tables in memory. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_TAB | HDB_5MIN | 5 MI |
| HDB_CS_H_ESTSIZE | Size of column tables estimated per host | Estimated size of column tables in memory, per host. | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_TAB | HDB_5MIN | 5 MI |
| HDB_CS_H_TOTSIZE | Total memory size of column tables per host | This KPI value represents the total memory size of column tables per host. By default, it does not include the persistent memory size (available since release 2.00.040). You might set the collector's parameter INCLUDE_PERS_MEMORY_SIZE to 'X' to include also persistent memory size into this KPI value. | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_TAB | HDB_5MIN | 5 MI |
| HDB_CS_MAINSIZE | Size of column tables in main memory | Under normal circumstances, the SAP HANA database manages the loading and unloading of tables into and from memory independently, the aim is to keep all relevant data in memory. However, you can manually load and unload individual tables, as well as load table columns if necessary. Size of column tables in the main memory is captured by this KPI. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_TAB | HDB_5MIN | 5 MI |
| HDB_CS_TOTALSIZE | Total memory size of column tables | This KPI value represents the total memory size of column tables. By default, it does not include the persistent memory size (available since release 2.00.040). You might set the collector's parameter INCLUDE_PERS_MEMORY_SIZE to 'X' to include also persistent memory size into this KPI value. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_TAB | HDB_5MIN | 5 MI |
| HDB_CS_UNLOADS | Number of unloads | The UNLOAD statement unloads the column store table from the memory. This can be done to free up memory. The table will be loaded again on the next access. The UNLOAD statement unloads the column store table from memory. The whole amount of unloads we can see in KPI with the name HDB_CS_UNLOADS. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_TAB | HDB_5MIN | 5 MI |
| HDB_CS_UNLOADS04 | Number of unloads priority 0 to 4 | Number of unloads with priority 0 to 4 displays this KPI. These are 9 priorities. Priority 0 to 4 is the most important of these all priorities. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_TAB | HDB_5MIN | 5 MI |
| HDB_CS_UNLOADS56 | Number of unloads priority 5 to 6 | This KPI shows the number of unloads priority 5 to 6. These are 9 priorities. Priority 5 to 6 is in the middle of these priorities. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_TAB | HDB_5MIN | 5 MI |
| HDB_CS_UNLOADS79 | Number of unloads priority 7 to 9 | KPI with the name HDB_CS_UNLOADS79 measures the number of unloads priority 7 to 9. These are 9 priorities. This priority is the least important. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_TAB | HDB_5MIN | 5 MI |
| HDB_CS_UNLOADSL | Number of unloads due to low memory | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_TAB | 5 MI | ||
| HDB_DISK_D_TOTAL | Used space on data disk per host | Used space on data disk per host, absolute value in GB | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_DISK | HDB_5MIN | 5 MI |
| HDB_DISK_D_USED | Used space on data backup disk per host | Used space on data backup disk per host, absolute value in GB | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_DISK | HDB_5MIN | 5 MI |
| HDB_DISK_DATA | Total size of data disks | Used space on log backup disk per host, absolute value in GB | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_DISK | HDB_5MIN | 5 MI |
| HDB_DISK_DBCK | Total used size on data disks | Used space on log disk per host, absolute value in GB | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_DISK | HDB_5MIN | 5 MI |
| HDB_DISK_L_TOTAL | Used space on log backup disk per host | Used space on log backup disk per host, absolute value in GB | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_DISK | HDB_5MIN | 5 MI |
| HDB_DISK_L_USED | Used space on log disk per host | Used space on log disk per host, absolute value in GB | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_DISK | HDB_5MIN | 5 MI |
| HDB_DISK_LBCK | Total size of log disks | ? | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_DISK | HDB_5MIN | 5 MI |
| HDB_DISK_LOG | Total used size on log disks | ? | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_DISK | HDB_5MIN | 5 MI |
| HDB_DISK_MAXDATA | Max. used space on data disks | ? | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_DISK | HDB_5MIN | 5 MI |
| HDB_DISK_MAXDBCK | Max. used space on data backup disks | Not displayed in charts | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_DISK | HDB_5MIN | 5 MI |
| HDB_DISK_MAXLBCK | Max. used space on log backup disks | Not displayed in charts | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_DISK | HDB_5MIN | 5 MI |
| HDB_DISK_MAXLOG | Max. used space on log disks | Total memory used by HANA database in GB | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_DISK | HDB_5MIN | 5 MI |
| HDB_DISK_MAXUSED | Max. used disk space | Percentage of allocated HANA memory used by the database. Recommendation is max 50% of memory used for data and the rest is reserved for calculation and intermediate results. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_DISK | HDB_5MIN | 5 MI |
| HDB_DM_COUNT | Number of small delta merge running for more than 60 sec | This KPI monitors changes in .ini file contents. If there is a changed parameter since the last monitoring run, it displays a number of changes and a related detail table shows the list of changed parameters with OLD and NEW values | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_DM | HDB_5MIN | 5 MI |
| HDB_DM_MAXRUN | Max. duration of small delta merge | Savepoints in the HANA database are responsible for the synchronization of memory pages with disks, which is necessary for system recovery. The frequency of savepoints is defined by using parameter global.ini -> [persistence] -> savepoint_interval_s. If this KPI exceeds the interval significantly, it means the savepoint was not successful and there is a synchronization issue. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_DM | HDB_5MIN | 5 MI |
| HDB_DUMPS | Number of HANA dumps | Number of dump files written by HANA. Should be 0, if there are any files, it means there were out-of-memory situations or crashes. You can view dump files via HANA studio. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_DUMP | HDB_5MIN | 5 MI |
| HDB_DUMPS_HOST | Number of HANA dumps per host | Number of dump files written by HANA. Should be 0, if there are any files, it means there were out-of-memory situations or crashes. You can view dump files via HANA studio. | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_DUMP | HDB_5MIN | 5 MI |
| HDB_FAILOVER | Number of hosts in failover status | Host auto-failover is a local fault recovery solution that can be used as a supplemental or alternative measure to system replication. One (or more) standby hosts are added to the SAP HANA system and configured to work in standby mode. The databases on the standby hosts do not contain any data and do not accept requests or queries as long as they are in standby mode. See the SAP Note 2057595. | HDB_HA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_HA | HDB_5MIN | 5 MI |
| HDB_IO_MINREAD | Min. I/O data read speed | To achieve optimal database performance, I/O activity (read/write accesses) should be evenly distributed on the database's hard disks. The KPI HDB_IO_MINREAD describes the minimal value of I/O data read speed. | HANA | SYS | only application server | Remote system | /DVD/MON_HDB_CL_COL_IO | HDB_5MIN | 5 MI |
| HDB_IO_MINWRITE | Min. I/O data write speed | To achieve optimal database performance, I/O activity (read/write accesses) should be evenly distributed on the database's hard disks. The KPI HDB_IO_MINWRITE describes the minimal value of I/O data write speed. | HANA | SYS | only application server | Remote system | /DVD/MON_HDB_CL_COL_IO | HDB_5MIN | 5 MI |
| HDB_IO_RR_DATA | Max. DATA read ratio | I/O calls are executed asynchronously; that is the thread does not wait for the order to return. A ratio close to 0 says the thread does not wait at all; a ratio close to 1 means the thread waits until the I/O request is completed because the asynchronous call is blocked (time for triggering I/O time for I/O completion). More information can be found in the SAP Note 1930979. This KPI shows the max DATA read ratio. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_IO | HDB_5MIN | 5 MI |
| HDB_IO_SER_READ | I/O data read speed per host | To achieve optimal database performance, I/O activity (read/write accesses) should be evenly distributed on the database's hard disks. DATA read ratio per server is displayed by this KPI. | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_IO | HDB_5MIN | 5 MI |
| HDB_IO_SER_RR | DATA read ratio per host | I/O calls are executed asynchronously; that means the thread does not wait for the order to return. A ratio close to 0 says the thread does not wait at all; a ratio close to 1 means the thread waits until the I/O request is completed because the asynchronous call is blocked (time for triggering I/O time for I/O completion). More information can be found in the SAP Note 1930979. DATA read ratio per server is displayed by this KPI. | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_IO | HDB_5MIN | 5 MI |
| HDB_IO_SER_WLOG | LOG write ratio per host | I/O calls are executed asynchronously; that means the thread does not wait for the order to return. A ratio close to 0 says the thread does not wait at all; a ratio close to 1 means the thread waits until the I/O request is completed because the asynchronous call is blocked (time for triggering I/O time for I/O completion). More information can be found in the SAP Note 1930979. This KPI measures LOG write ratio per server. | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_IO | HDB_5MIN | 5 MI |
| HDB_IO_SER_WR | DATA write ratio per host | I/O calls are executed asynchronously; that means the thread does not wait for the order to return. A ratio close to 0 says the thread does not wait at all; a ratio close to 1 means the thread waits until the I/O request is completed because the asynchronous call is blocked (time for triggering I/O time for I/O completion). More information can be found in the SAP Note 1930979. DATA write ratio per server is captured by this KPI. | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_IO | HDB_5MIN | 5 MI |
| HDB_IO_SER_WRITE | I/O data write speed per host | I/O calls are executed asynchronously; that means the thread does not wait for the order to return. A ratio close to 0 says the thread does not wait at all; a ratio close to 1 means the thread waits until the I/O request is completed because the asynchronous call is blocked (time for triggering I/O time for I/O completion). More information can be found in the SAP Note 1930979. I/O data write speed server is collected by KPI with the name HDB_IO_WR_DATA. | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_IO | HDB_5MIN | 5 MI |
| HDB_IO_WR_DATA | Max. DATA write ratio | I/O calls are executed asynchronously; that means the thread does not wait for the order to return. A ratio close to 0 says the thread does not wait at all; a ratio close to 1 means the thread waits until the I/O request is completed because the asynchronous call is blocked (time for triggering I/O time for I/O completion). More information can be found in the SAP Note 1930979. Maximal DATA write ratio is measured by this KPI. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_IO | HDB_5MIN | 5 MI |
| HDB_IO_WR_LOG | Max. LOG write ratio | I/O calls are executed asynchronously; that means the thread does not wait for the order to return. A ratio close to 0 says the thread does not wait at all; a ratio close to 1 means the thread waits until the I/O request is completed because the asynchronous call is blocked (time for triggering I/O time for I/O completion). More information can be found in the SAP Note 1930979. This KPI shows a maximal LOQ write ratio. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_IO | HDB_5MIN | 5 MI |
| HDB_BCK_FAIL_DAT | Number of failed DATA backups | When the DATA backup is performed with some errors, a number of failed backups is recorded by this KPI. The KPI recognizes two classifications of failure on 'complete data backup' and 'data snapshot' | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_BCK | HDB_5MIN | 6 MI |
| HDB_BCK_FAIL_LOG | Number of failed LOG backups | When the LOG backup is performed with some errors, a number of failed backups is recorded by this KPI. The KPI recognizes two classifications of failure on 'log backup' and 'log missing' | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_BCK | HDB_5MIN | 7 MI |
| HDB_LOG_BUFWAITP | Buffer switches with Wait on buffer semaphore % (max host) | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_BCK | HDB_5MIN | 5 MI | |
| HDB_LOG_BUFWAITT | Number of Buffer switches wait since the last check | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_BCK | HDB_5MIN | 5 MI | |
| HDB_LOG_BUFWNOWT | Number of Buffer switches (noWait+wait) since the last check | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_BCK | HDB_5MIN | 5 MI | |
| HDB_LOG_SEG_FREE | Minimum number of Free log segments (per hosts) | This KPI shows the lowest value for all nodes (it does not show the value for each node). If this KPI is 0 then the log backup will be delayed and may cause a crash. If low, see the content of the table /DVD/MON_HDBLOGS in the satellite system to see on which node is the issue. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_BCK | HDB_5MIN | 5 MI |
| HDB_LOG_SEG_TRNC | Maximum number of Truncated log segments (per hosts) | This KPI shows the highest value for all nodes (it does not show the value for each node) If high value, see the content of the table /DVD/MON_HDBLOGS to see on which node is the issue. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_BCK | HDB_5MIN | 5 MI |
| HDB_MEM_ALLOCLIM | Global memory allocation limit for the database | Not displayed in charts | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_MEM | HDB_5MIN | 5 MI |
| HDB_MEM_CACHE_P | Memory used by caches per host | Percentage of host memory used by caches | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_MEM | HDB_5MIN | 5 MI |
| HDB_MEM_CS_P | Memory used by column store per host | Percentage of host memory used by column store. If this component grows rapidly, consider housekeeping or archiving solutions. Check out Datavard Outboard | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_MEM | HDB_5MIN | 5 MI |
| HDB_MEM_HOST_P | Used physical memory per host | Physical memory is the main memory, the RAM. Unlike physical memory, virtual memory can be allocated by the SAP system. The operating system determines if the allocated memory area resides in the physical memory or in the operating system swap/page space. Percentage of the utilization of physical memory per host is displayed by this KPI. | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_MEM | HDB_5MIN | 5 MI |
| HDB_MEM_MAX_P | Maximum used physical memory on hosts | Physical memory is the main memory, the RAM. Unlike physical memory, virtual memory can be allocated by the SAP system. The operating system determines if the allocated memory area resides in the physical memory or in the operating system swap/page space. Maximum used physical memory around 94% is normal. This KPI says about maximal use of physical memory on all hosts. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_MEM | HDB_5MIN | 5 MI |
| HDB_MEM_SQL_P | Memory used by SQL exec & results per host | Percentage of host memory used by SQL execution and intermediate results. If this area grows, it can indicate too expensive/inefficient SQL statements. Please check the list of expensive SQL statements in the DB02 transaction. | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_MEM | HDB_5MIN | 5 MI |
| HDB_MEM_SRVHOSTD | Percentage of used service memory per host – Delta | SAP HANA system consists of multiple services that all consume the memory, in particular, the index server service, the main database service. The index server holds all data tables and temporary results and therefore uses most of SAP HANA used memory. This KPI displays the delta in the percentage of used service memory per host. | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_MEM | HDB_5MIN | 5 MI |
| HDB_MEM_SRVHOSTP | Database memory used per host | SAP HANA system consists of multiple services where each service consumes the memory. This KPI value calculates the used memory for the main database service 'indexserver'. The service 'indexserver' holds all the data tables and temporary results, therefore, dominates for SAP HANA used memory. This KPI displays the percentage of used service memory per host. By default, it does not include the persistent memory size. You might set the collector's parameter INCLUDE_PERS_MEMORY_SIZE to 'X' to include also persistent memory size into this KPI value. | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_MEM | HDB_5MIN | 5 MI |
| HDB_MEM_SRVUSEDP | Maximum database memory used on hosts | This KPI calculates the % of max used memory on all hosts. By default, it does not include the persistent memory size. You might set the collector's parameter INCLUDE_PERS_MEMORY_SIZE to 'X' to include also persistent memory size into this KPI value. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_MEM | HDB_5MIN | 5 MI |
| HDB_MEM_STAT_P | Memory used by monitoring & statistics per host | Percentage of host memory used by monitoring and statistics server. In case of memory growth, check the SAP note 2147247. | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_MEM | HDB_5MIN | 5 MI |
| HDB_MEM_SYS_P | Memory used by the system per host | Percentage of host memory used by a database system (not operating system!). If this component grows rapidly, it can be caused by a memory leak in the HANA system and has to be fixed by the HANA upgrade. | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_MEM | HDB_5MIN | 5 MI |
| HDB_MEM_TOTAL | Total physical memory on HANA available | Not displayed in charts | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_MEM | HDB_5MIN | 5 MI |
| HDB_MEM_USED | Total physical memory used | Physical memory is the main memory, the RAM. Unlike physical memory, virtual memory can be allocated by the SAP system. The operating system determines if the allocated memory area resides in the physical memory or in the operating system swap/page space. Total use of physical memory is represented by this KPI. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_MEM | HDB_5MIN | 5 MI |
| HDB_MEM_USED_DB | Total memory used by database | Total memory used by HANA database in GB | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_MEM | HDB_5MIN | 5 MI |
| HDB_MEM_USED_P | Total database memory used | Percentage of allocated HANA memory used by a database. Recommendation is max 50% of memory used for data and the rest is reserved for calculation and intermediate results. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_MEM | HDB_5MIN | 5 MI |
| HDB_MVCC_CL_FILE | HDB MVCC Number of cleanup file | This KPI is collected using HANA System View M_UNDO_CLEANUP_FILES. Each undo or cleanup file in the system is represented by one row in this view. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_MVCC | HDB_5MIN | 5 MI |
| HDB_MVCC_MAXHOST | HDB MVCC max number of versions per host | Multiversion Concurrency Control (MVCC). The main advantage of using the MVCC model of concurrency control rather than locking, is that in MVCC locks acquired for querying (reading) data do not conflict with locks acquired for writing data and so reading never blocks writing and writing never blocks reading. This KPI shows a maximal number of versions per host using MVCC. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_MVCC | HDB_5MIN | 5 MI |
| HDB_NET_HOST_IN | HANA received via network - average per minute | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_NET | 5 MI | ||
| HDB_NET_HOST_INM | HANA received via network (max. minute avg. from all hosts) | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_NET | 5 MI | ||
| HDB_NET_HOST_IP | HANA received via network – traffic peak | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_NET | 5 MI | ||
| HDB_NET_HOST_IPM | HANA received via network – traffic peak from all hosts | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_NET | 5 MI | ||
| HDB_NET_HOST_OP | HANA sent via network – traffic peak | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_NET | 5 MI | ||
| HDB_NET_HOST_OPM | HANA sent via network – traffic peak from all hosts | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_NET | 5 MI | ||
| HDB_NET_HOST_OUM | HANA sent via network (max. minute avg. from all hosts) | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_NET | 5 MI | ||
| HDB_NET_HOST_OUT | HANA sent via network - average per minute | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_NET | 5 MI | ||
| HDB_NET_PING | HANA Network Client Duration - per host | The measured ping times include the communication between nameserver and indexserver and KPI collection within the indexserver. Increased times can be a symptom of an underlying performance issue. Check for general issues impacting the performance (e.g., resource bottlenecks). | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_NET | HDB_5MIN | 5 MI |
| HDB_NET_RATIO | HANA Network Client Duration - max all hosts | Ratio between network time and total client+server time of a request. For example, 30% means that on average the request spent 30% of the time on network transfer. If this value is high, it can indicate network bottlenecks. To enable this KPI, you need to set the HANA parameter: indexserver.ini -> [sql_client_network_io] -> enabled. See the SAP Note 2222200. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_NET | HDB_5MIN | 5 MI |
| HDB_NET_SPEED | HANA Network Server Duration - per host | Average network throughput between HANA clients and servers To enable this KPI, you need to set the HANA parameter: indexserver.ini -> [sql_client_network_io] -> enabled. See the SAP Note 2222200. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_NET | HDB_5MIN | 5 MI |
| HDB_NET_TRAFFIC | HANA Network Server Duration - max all hosts | Total amount of data transferred via network between HANA clients and servers in last 5 minutes To enable this KPI, you need to set the HANA parameter: indexserver.ini -> [sql_client_network_io] -> enabled. See the SAP Note 2222200. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_NET | HDB_5MIN | 5 MI |
| HDB_NETCLI | HANA Network Service response time - per host | HANA Network Client Duration per host is displayed by this KPI. | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_NET | HDB_5MIN | 5 MI |
| HDB_NETCLIM | HANA Network Service response time - max all hosts | This KPI shows HANA Network Client Duration - max all hosts. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_NET | HDB_5MIN | 5 MI |
| HDB_NETSER | Index server ping time per host | Server duration per host is measured by KPI with the name HDB_NETSER. | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_NET | HDB_5MIN | 5 MI |
| HDB_NETSERM | Network I/O ratio | HANA Network Server Duration - max all hosts are displayed by this KPI. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_NET | HDB_5MIN | 5 MI |
| HDB_NETSERVRESP | Network throughput | Service response time per host for HANA Network is captured by this KPI. | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_NET | HDB_5MIN | 5 MI |
| HDB_NETSERVRESPM | Network traffic in last 5 minutes | This KPI shows HANA Network Service response time - max all hosts. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_NET | HDB_5MIN | 5 MI |
| HDB_OLCK_AGE | Age of the oldest Object Lock | Locks are set on HANA objects to guarantee data integrity. It can happen that a lock remains too long (due to some bug or bad design) and this will impact users (waiting for the lock to be removed) and operation (too many cleanup files, many threads, etc.). Monitoring view M_OBJECT_LOCKS provides the status of currently acquired locks on objects with detailed information such as lock acquisition time, lock mode. The KPI HDB_OLCK_AGE "Age of the oldest Object Lock" is the oldest lock as shown by monitoring view M_OBJECT_LOCKS. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_OBJECTLOCK | HDB_5MIN | 5 MI |
| HDB_OLCK_COUNTX | Number of Object Locks older than X minutes | Locks are set on HANA objects to guarantee data integrity. It can happen that a lock remains too long (due to some bug or bad design) and this will impact users (waiting for the lock to be removed) and operation (too many cleanup files, many threads, etc.). Monitoring view M_OBJECT_LOCKS provides the status of currently acquired locks on objects with detailed information such as lock acquisition time, lock mode. The KPI HDB_OLCK_COUNTX "Number of Object Locks older than X minutes" is the number of locks in monitoring view M_OBJECT_LOCKS that have acquisition time older than x minutes. X is customizable with collector parameter LOCK_COUNT_OLDER_X_MINUTES, by default 5 minutes. Number of object lock older than X minutes is displayed by KPI with the name HDB_OLCK_COUNTX. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_OBJECTLOCK | HDB_5MIN | 5 MI |
| HDB_PARAM_CH | Count of changed HANA parameters | This KPI monitors changes in .ini file contents. If there is a changed parameter since the last monitoring run, it displays a number of changes and the related detail table shows a list of changed parameters with OLD and NEW values | HANA | SYS | only application server | Remote system | /DVD/MON_HDB_CL_COL_PAR | HDB_5MIN | 5 MI |
| HDB_PART_CNT_ABX | Number of partitions above XXX million rows | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_TAB | HDB_1DAY | 1 DA | |
| HDB_PCACHE_EVICD | SQL Plan Cache Eviction Delta max all host | It shows a maximum change of plan eviction detected on all hosts for the last snapshots. | HANA | SYS | any server | Central system | /DVD/MON_HDB_CL_COL_SQL_PLAN | HDB_5MIN | 5 MI |
| HDB_PCACHE_EVICH | SQL Plan Cache Eviction per host | It shows how many times the plan eviction occurred on a host. If the plan cache eviction is too high, it means that SQL plan cache capacity is not big enough, and too many compilations occur. | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_SQL_PLAN | HDB_5MIN | 5 MI |
| HDB_PCACHE_EVIDH | SQL Plan Cache Eviction Delta per host | It shows the change of a plan eviction on a host in comparison with the last KPI snapshot. | HANA | SER | only database server | Central system | /DVD/MON_HDB_CL_COL_SQL_PLAN | HDB_5MIN | 5 MI |
| HDB_PCACHE_HR_SR | SQL Plan Cache Hit Ratio per host | The hit ratio is the percentage of pages found in the cache without having to read from the disk. The ratio shows the average percentage of data pages found in the cache since SQL Server was started. This KPI displays SQL Plan Cache Hit Ratio per host. | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_SQL_PLAN | HDB_5MIN | 5 MI |
| HDB_PLANCACHE_HR | Min. SQL Plan Cache Hit Ratio | The hit ratio is the percentage of pages found in the cache without having to read from the disk. The ratio shows the average percentage of data pages found in the cache since SQL Server was started. Minimal SQL Plan Cache Hit Ratio is measured by this KPI. | HANA | SYS | only application server | Remote system | /DVD/MON_HDB_CL_COL_SQL_PLAN | HDB_5MIN | 5 MI |
| HDB_REP_DELAY | System replication: Log shipping delay | Log shipping delay occurred during the system replication from primary to a secondary site. Check for errors or communication issues that can be responsible for the log shipping delays and make sure that the log can be shipped in time. See the SAP note 1999880. | HDB_HA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_HA | HDB_5MIN | 5 MI |
| HDB_REP_ERROR | Number of system replication errors | There was an error during the system replication between the primary and secondary sites. Analyze the related trace files in order to understand the reason for the problems and make sure that system replication is again established. See the SAP note 1999880. | HDB_HA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_HA | HDB_5MIN | 5 MI |
| HDB_REP_SS_AGE | Age of oldest replication snapshot | Database snapshots can increase the data disk space requirements and you should make sure that system replication-related snapshots are not kept longer than necessary. The snapshot retention time is controlled by the following parameter: global.ini -> [system_replication] -> datashipping_snapshot_max_retention_time See the SAP note 1999880. | HDB_HA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_HA | HDB_5MIN | 5 MI |
| HDB_REP_UNKNOWN | Number of unknown replication statuses | There was an error during the system replication between the primary and secondary sites. Analyze the related trace files in order to understand the reason for the problems and make sure that system replication is again established. See the SAP note 1999880. | HDB_HA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_HA | HDB_5MIN | 5 MI |
| HDB_RS_ALLOC | Row store allocated size | This KPI shows row store allocated size. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_TAB | HDB_5MIN | 5 MI |
| HDB_RS_FRAG | Row store fragmentation | Row store grows by allocating a 64MB memory segment and shrinks by freeing empty segments. A segment is internally divided into fixed-size pages. When a row store table requires more memory to store records, the table takes a free page from existing segments. If no segment has a free page, a new segment is allocated. Deleting a large number of records may result in a number of sparse segments. In such a case, a row store reorganization can be performed for memory compaction. The pages in sparse segments are moved to other segments and the resultant empty segments are freed. If the row store fragmentation exceeds 30%, row store reorganization is recommended. See the SAP Note 1813245. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_TAB | HDB_5MIN | 5 MI |
| HDB_SP_COUNT | Number of savepoints | During a savepoint, the database system writes the data which has changed since the last savepoint from the data cache (working memory) to the data area (permanent storage). The data written during a savepoint always represents a consistent state of the database. During a savepoint, the database system does not overwrite the pages written to the data area at the previous savepoint, but instead writes the changed data to free positions. This is because the database system requires this information from the previous savepoint for a restart if there is a system failure during the new savepoint. Only after the database system has successfully completed a new savepoint, it releases the pages of the old savepoint in the data area for overwriting. This KPI shows a number of savepoints. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_SP | HDB_5MIN | 5 MI |
| HDB_SP_LAST | Time since the last savepoint | Savepoints in the HANA database are responsible for the synchronization of memory pages with disks, which is necessary for system recovery. The frequency of savepoints is defined using parameter global.ini -> [persistence] -> savepoint_interval_s. If this KPI exceeds the interval significantly, it means savepoint was not successful and there is a synchronization issue. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_SP | HDB_5MIN | 5 MI |
| HDB_SP_MAXRUN | Max. duration of a savepoint | During a savepoint, the database system writes the data which has changed since the last savepoint from the data cache (working memory) to the data area (permanent storage). The data written during a savepoint always represents a consistent state of the database. During a savepoint, the database system does not overwrite the pages written to the data area at the previous savepoint, but instead writes the changed data to free positions. This is because the database system requires this information from the previous savepoint for a restart if there is a system failure during the new savepoint. Only after the database system has successfully completed the new savepoint, it releases the pages of the old savepoint in the data area for overwriting. This KPI shows the maximal duration of savepoint. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_SP | HDB_5MIN | 5 MI |
| HDB_SP_MAXRUN_C | Max. critical phase duration of a savepoint | During a savepoint, the database system writes the data which has changed since the last savepoint from the data cache (working memory) to the data area (permanent storage). The data written during a savepoint always represents a consistent state of the database. During a savepoint, the database system does not overwrite the pages written to the data area at the previous savepoint, but instead writes the changed data to free positions. This is because the database system requires this information from the previous savepoint for a restart if there is a system failure during the new savepoint. Only after the database system has successfully completed the new savepoint, it releases the pages of the old savepoint in the data area for overwriting. To perform a savepoint write operation, SAP HANA needs to take a global database lock. This period is called the “critical phase” of a savepoint. The max. critical phase duration of a savepoint is displayed by this KPI. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_SP | HDB_5MIN | 5 MI |
| HDB_SP_SPEED | Savepoint speed | During a savepoint, the database system writes the data which has changed since the last savepoint from the data cache (working memory) to the data area (permanent storage). The data written during a savepoint always represents a consistent state of the database. During a savepoint, the database system does not overwrite the pages written to the data area at the previous savepoint, but instead writes the changed data to free positions. This is because the database system requires this information from the previous savepoint for a restart if there is a system failure during the new savepoint. Only after the database system has successfully completed the new savepoint, it releases the pages of the old savepoint in the data area for overwriting. This KPI shows the savepoint speed. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_SP | HDB_5MIN | 5 MI |
HDB_SQL_EXP_STMT_NUM | Number of expensive statements exceeding the memory limit | Expensive statements are individual SQL statements whose peak memory size exceeds a configured threshold during their execution. The threshold is configured as a collector's parameter MEMORY_SIZE_LIMIT_IN_MB with the default value 500MB. The KPI represents a number of expensive SQL statements which are recognized from the last monitoring snapshot. The SQL statement is stored in the Detail table "HANA expensive statements" with additional information as are - which application or user executed it, how long it was running, and maximum memory consumed by the execution. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_SQL_STMT | HDB_5MIN | 5 MI |
| HDB_SRV_RESTART | Number of restarted index services | Restart of an index server can indicate a node failover or another crash situation. | HDB_HA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_HA | HDB_5MIN | 5 MI |
| HDB_THR_BACKUP | Max. duration of Backup threads | A backup, or the process of backing up, refers to the copying and archiving of data so it may be used to restore the original after a data loss event. Maximum duration of backup threads are displayed by KPI is called HDB_THR_BACKUP. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_THREAD | HDB_5MIN | 5 MI |
| HDB_THR_COUNT | Number of active HANA threads | The SAP NetWeaver Application Server provides logical services for processing the workload mapped through operation system processes. These include the dispatcher and work processes of the ABAP server, which are each implemented on UNIX derivatives as separate operating system processes and on Windows operating systems through what are known as threads within a process. The active threads, which exist in HANA are monitored by KPI with the name HDB_THR_COUNT. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_THREAD | HDB_5MIN | 5 MI |
| HDB_THR_JOBWRUN | Thread JobWorker Running max all hosts | HANA | SYS | any server | Central system | /DVD/MON_HDB_CL_COL_THREAD | HDB_5MIN | 5 MI | |
| HDB_THR_JOBWRUNH | Thread JobWorker Running per host | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_THREAD | HDB_5MIN | 5 MI | |
| HDB_THR_JOBWTTL | Thread JobWorker Total max all hosts | HANA | SYS | any server | Central system | /DVD/MON_HDB_CL_COL_THREAD | HDB_5MIN | 5 MI | |
| HDB_THR_JOBWTTLH | Thread JobWorker Total per host | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_THREAD | HDB_5MIN | 5 MI | |
| HDB_THR_LOCKED | Number of threads waiting for locks | Number of threads waiting for various types of locks. If there are long running locks, please find the lock type in the detail table with threads and check the SAP Note 1999998. | HANA | SYS | Remote system | /DVD/MON_HDB_CL_COL_THREAD | HDB_5MIN | 5 MI | |
| HDB_THR_MAXRUN | Max. duration of HANA threads | Maximum duration of all running HANA threads. | HANA | SYS | Remote system | /DVD/MON_HDB_CL_COL_THREAD | HDB_5MIN | 5 MI | |
| HDB_THR_MC_CPUT | MemoryCompactor CPU Time (ratio per sec) Max all host | KPI HDB_THR_MC_CPUT is a maximum ratio between the delta CPU time of the thread and the number of seconds between 2 snapshots on each host. It’s a number of parallel threads that are processed by MemoryCompactor (also called incorrectly Garbage Collector). When “defragmentation” / thread MemoryCompactor is running, ERP is slow and can be extremely slow as defragmentation requires an IPMM lock (it can create locks on NRIV or other critical tables). | HANA | SYS | Remote system | /DVD/MON_HDB_CL_COL_THREAD | HDB_5MIN | 5 MI | |
| HDB_THR_MC_CPUTH | MemoryCompactor CPU Time (ratio per sec) per host | HDB_THR_MC_CPUTH is a ratio between the delta CPU time of the thread and the number of seconds between 2 snapshots on each host. It’s a number of parallel threads that are processed by MemoryCompactor (also called incorrectly Garbage Collector). When “defragmentation” / thread MemoryCompactor is running, ERP is slow and can be extremely slow as defragmentation requires an IPMM lock (it can create locks on NRIV or other critical tables). | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_THREAD | HDB_5MIN | 5 MI |
| HDB_THR_MERGEDOG | Max. duration of MergeDog threads | A system process called “MergeDog” periodically checks the merges to the storage server and for which auto-merge is enabled. It then determines for each individual table (or single partition of split storage) if a merge should be executed based on configurable criteria. This KPI shows the maximal duration of MergeDog threads. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_THREAD | HDB_5MIN | 5 MI |
| HDB_THR_REPLICA | Maximum runtime of replications | This is the time taken for replicating the data from the primary site to the secondary. Long time of replication is always after the backup. So, it can be co-related with the KPI Max duration of the backup thread. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_THREAD | HDB_5MIN | 5 MI |
| HDB_THR_SQLEC1 | Thread SqlExecutor Count Running > 1minute | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_THREAD | HDB_5MIN | 5 MI | |
| HDB_THR_SQLERUN | Thread SqlExecutor Running max all hosts | HANA | SYS | any server | Central sustem | /DVD/MON_HDB_CL_COL_THREAD | HDB_5MIN | 5 MI | |
| HDB_THR_SQLERUNH | Thread SqlExecutor Running per host | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_THREAD | HDB_5MIN | 5 MI | |
| HDB_THR_SQLETTL | Thread SqlExecutor Total max all hosts | HANA | SYS | any server | Central system | /DVD/MON_HDB_CL_COL_THREAD | HDB_5MIN | 5 MI | |
| HDB_THR_SQLETTLH | Thread SqlExecutor Total per host | HANA | SER | only database server | Remote system | /DVD/MON_HDB_CL_COL_THREAD | HDB_5MIN | 5 MI | |
| HDB_THR_SQLRUN | Max. duration of SqlExecutor threads | These thread types handle incoming client requests and execute simple statements. For each statement execution, a SqlExecutor thread from a thread pool processes the statement. For simple (OLTP-like) statements against the column store as well as for most statements against the row store, this will be the only type of thread involved. This KPI shows the maximal duration of SqlExecutor threads. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_THREAD | HDB_5MIN | 5 MI |
| HDB_THR_TIME_CAP | Time to capture threads | Runtime to read all thread data from HANA monitoring view | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_THREAD | HDB_5MIN | 5 MI |
| HDB_TRAN_BLOCK_C | Number of blocked transactions | Blocked transactions are transactions that are unable to be processed further because they need to acquire transactional locks (record or table locks) that are currently held by another transaction. Transactions can also be blocked waiting for other resources such as network or disk (database or metadata locks). You can lock and unlock transaction codes in SM01. This KPI shows a number of blocked transactions. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_TRAN | HDB_5MIN | 5 MI |
| HDB_TRAN_BLOCK_T | Duration of longest transaction lock wait | Some transactions are waiting too long for a DB lock, most probably some long-running program didn't release a lock using DB commit and blocks other transactions. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_TRAN | HDB_5MIN | 5 MI |
| HDB_TRAN_REDO | Maximum redo size of the current transaction | To enable point-in-time recovery for the database system, the DB writer REDO logs after every COMMIT. These logs are used to reply to changes recorded since the last full backup. Check if you can reduce the amount of performed change operations. | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_TRAN | HDB_5MIN | 5 MI |
| HDB_TRAN_UNDO | Maximum undo size of the current transaction | HANA | SYS | any server | Remote system | /DVD/MON_HDB_CL_COL_TRAN | HDB_5MIN | 5 MI | |
| HEAP_DIA | Dialog heap memory (server) | This KPI represents the amount of heap memory (Private Memory) that an SAP dialog work process can allocate on the application server. Official parameter for this KPI is abap/heap_area_dia. | SAPSYS | SER | only application server | Remote system | /DVD/MON_CL_COL_HEAP | DEF_5MIN | 5 MI |
| HEAP_NONDIA | Non-dialog heap memory (server) | This KPI represents the amount of heap memory (Private Memory) that an SAP non-dialog work process can allocate on the application server. This value refers to spool, update, and background processes. Official parameter of this KPI is abap/heap_area_nondia. | SAPSYS | SER | only application server | Remote system | /DVD/MON_CL_COL_HEAP | DEF_5MIN | 5 MI |
| HEAP_TOTAL | Heap memory available (server) | This KPI represents the total size of heap memory assigned for the application server. This value contains dialog and non-dialog heap memory sizes combined. Official parameter of this KPI is abap/heap_area_total | SAPSYS | SER | only application server | Remote system | /DVD/MON_CL_COL_HEAP | DEF_5MIN | 5 MI |
| HEAP_USED_DIA | Dialog heap memory used (server) | KPI value represents how much dialog heap memory is used at a specific time for the application server. Only dialog work processes can use this private memory. | SAPSYS | SER | only application server | Remote system | /DVD/MON_CL_COL_HEAP | DEF_5MIN | 5 MI |
| HEAP_USED_DIA_P | Percentage of used dialog heap memory (server) | KPI value represents the percentage of how much dialog heap memory is used at a specific time for the application server. Only dialog work processes can use this private memory. | SAPSYS | SER | only application server | Remote system | /DVD/MON_CL_COL_HEAP | DEF_5MIN | 5 MI |
| HEAP_USED_DIA_P_SYS_MAX | Maximum of used dialog heap memory (all servers) | KPI value represents the percentage of used dialog heap memory across all application servers. | SAPSYS | SYS | only application server | Central system | /DVD/MON_CL_COL_HEAP | DEF_5MIN | 5 MI |
| HEAP_USED_NONDIA | Non-dialog heap memory used (server) | KPI value represents how much non-dialog heap memory is used at a specific time for the application server. Only non-dialog work processes can use this private memory. | SAPSYS | SER | only application server | Remote system | /DVD/MON_CL_COL_HEAP | DEF_5MIN | 5 MI |
| HEAP_USED_NONDIA_P | Percentage of used non-dialog heap memory (server) | KPI value represents the percentage of how much non-dialog heap memory is used at a specific time for the application server. Only non-dialog work processes can use this private memory. | SAPSYS | SER | only application server | Remote system | /DVD/MON_CL_COL_HEAP | DEF_5MIN | 5 MI |
| HEAP_USED_NONDIA_P_SYS_MAX | Maximum of used non-dialog heap memory (all servers) | KPI value represents the percentage of used non-dialog heap memory across all application servers. | SAPSYS | SYS | only application server | Central system | /DVD/MON_CL_COL_HEAP | DEF_5MIN | 5 MI |
| HEAP_USED_TOTAL | Heap memory used (server) | This KPI represents the total size of allocated heap memory in time for the application server. KPI defines how much of the total heap is used with dialog and non-dialog work processes combined. | SAPSYS | SER | only application server | Remote system | /DVD/MON_CL_COL_HEAP | DEF_5MIN | 5 MI |
| HEAP_USED_TOTAL_P | Percentage of used heap memory (server) | This KPI represents the percentage of total size for allocated heap memory in time for the application server. KPI defines how much of the total heap is used with dialog and non-dialog work processes combined. | SAPSYS | SER | only application server | Remote system | /DVD/MON_CL_COL_HEAP | DEF_5MIN | 5 MI |
| HEAP_USED_TOTAL_P_SYS_MAX | Maximum of used heap memory (all servers) | KPI value represents the percentage of used total heap memory (dialog + non-dialog) across all application servers. | SAPSYS | SYS | only application server | Central System | /DVD/MON_CL_COL_HEAP | DEF_5MIN | 5 MI |
| HMBS_A_HK | HeatMap: Analysis Profile - Dummy KPI | Execution of Housekeeping analysis on satellite system | HMCCAE | SYS | any server | Remote system | /DVD/HMCC_CL_COL_RL_ANL | HMBS_A_HK | |
| HMBS_A_TTB (OBSOLETE) | HeatMap: Analysis Profile - Dummy KPI | HMCCAE | SYS | any server | Remote system | /DVD/HMCC_CL_COL_RL_ANL | HMBS_A_TTB | ||
| HMBS_E_HK | HeatMap: ETL Profile - Dummy KPI | Housekeeping analysis extraction of analyzed data from the satellite system | HMCCAE | SYS | any server | Central system | /DVD/HMCC_CL_COL_RL_ETL | HMBS_E_HK | |
| HMBS_E_RAL | HeatMap: ETL Profile - Dummy KPI | HMCCAE | SYS | any server | Central system | /DVD/HMCC_CL_COL_RL_ETL | HMBS_E_RAL | ||
| HMBS_E_SS | HeatMap: ETL Profile - Dummy KPI | System size KPI | HMCCAE | SYS | any server | Central system | /DVD/HMCC_CL_COL_RL_ETL | HMBS_E_SS | |
| HMBS_S_STD | HeatMap: ETL Profile - Dummy KPI | HMCCAE | SYS | any server | Remote system | /DVD/HMBS_COL_STAD | HMBS_S_STD | 10 MI | |
| HMBW_DTP_QR_RECORD | Heatmap data for DTP and Query collected records | Collection of DTP and query usage analysis on the central system | HMBW | SYS | any server | Central system | /DVD/MON_HM_CL_COL_DTP_QR | HMBW_1DAY | |
| HMBW_DTP_QR_RECORD_R | Heatmap data for DTP and Query collected records - remote | Extraction of data for DTP and query usage analysis on the central system | HMBW | SYS | any server | Remote system | /DVD/MON_HM_CL_COL_DTP_QR | HMBW_1DAY | |
| HMBW_DU_RECORD | HMBW Data Usage collected records | Collection and aggregation of Data distribution analysis data on the central system | HMBW | SYS | any server | Central system | /DVD/MON_HM_CL_COL_DU | HMBW_1DAY | |
| HMBW_DU_RECORD_R | HMBW Data Usage collected - remote | Execution and collection of Data distribution analysis data on satellite system | HMBW | SYS | any server | Remote system | /DVD/MON_HM_CL_COL_DU | HMBW_1DAY | |
| HMBW_QU_RECORD | HMBW QueryUsage collected records | Collection and aggregation of query usage analysis data on the central system | HMBW | SYS | any server | Central system | /DVD/MON_HM_CL_COL_QU | HMBW_1DAY | 1 DA |
| HMBW_QU_RECORD_R | HMBW Query Usage collected - remote | Execution and collection of query usage analysis data on the satellite system | HMBW | SYS | any server | Remote system | /DVD/MON_HM_CL_COL_QU | HMBW_1DAY | 1 DA |
| HMCC_A | HeatMap: Analysis Profile - Dummy KPI | HMCCAE | SYS | any server | Remote system | /DVD/HMCC_CL_COL_RL_ANL | |||
| HMCC_E | HeatMap: ETL Profile - Dummy KPI | HMCCAE | SYS | any server | Central system | /DVD/HMCC_CL_COL_RL_ETL | |||
| HMER_A_ACH (OBSOLETE) | HeatMap: Analysis Profile - Dummy KPI | HMCCAE | SYS | any server | Remote system | /DVD/HMCC_CL_COL_RL_ANL | HMER_A_ACH | ||
| HMER_A_ACO (OBSOLETE) | HeatMap: Analysis Profile - Dummy KPI | HMCCAE | SYS | any server | Remote system | /DVD/HMCC_CL_COL_RL_ANL | HMER_A_ACO | ||
| HMER_A_AEC (OBSOLETE) | HeatMap: Analysis Profile - Dummy KPI | HMCCAE | SYS | any server | Remote system | /DVD/HMCC_CL_COL_RL_ANL | HMER_A_AEC | ||
| HMER_A_AFI (OBSOLETE) | HeatMap: Analysis Profile - Dummy KPI | HMCCAE | SYS | any server | Remote system | /DVD/HMCC_CL_COL_RL_ANL | HMER_A_AFI | ||
| HMER_A_ALE (OBSOLETE) | HeatMap: Analysis Profile - Dummy KPI | HMCCAE | SYS | any server | Remote system | /DVD/HMCC_CL_COL_RL_ANL | HMER_A_ALE | ||
| HMER_A_AMM (OBSOLETE) | HeatMap: Analysis Profile - Dummy KPI | HMCCAE | SYS | any server | Remote system | /DVD/HMCC_CL_COL_RL_ANL | HMER_A_AMM | ||
| HMER_A_ASD (OBSOLETE) | HeatMap: Analysis Profile - Dummy KPI | HMCCAE | SYS | any server | Remote system | /DVD/HMCC_CL_COL_RL_ANL | HMER_A_ASD | ||
| HMER_A_UEG (OBSOLETE) | HeatMap: Analysis Profile - Dummy KPI | HMCCAE | SYS | any server | Remote system | /DVD/HMCC_CL_COL_RL_ANL | HMER_A_UEG | ||
| HMER_C_CCL (OBSOLETE) | HeatMap: Central Collector - Dummy KPI | HMCCAE | SYS | any server | Central system | /DVD/EHMC_CL_COL_CCLDR | HMER_C_CCL | ||
| ICM_CURR_CONN | Current connections count (server) | KPI value represents a total number of currently used connections to the application server. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_ICM | DEF_5MIN | 5 MI |
| ICM_CURR_QUE | Number of current entries in queue (server) | KPI value represents how many entries are currently in the request queue. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_ICM | DEF_5MIN | 5 MI |
| ICM_CURR_THR | Number of all threads (server) | KPI represents the number of all available threads on the application server. This contains threads either in running/idle/completed state. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_ICM | DEF_5MIN | 5 MI |
| ICM_IDLE_THR | Number of idle threads (server) | KPI value represents the number of running threads that are in an idle state on the application server. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_ICM | DEF_5MIN | 5 MI |
| ICM_MAX_CONN | Maximum limit for allowed connections (server) | KPI value represents how many connections can be maintained by the application server at the same time. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_ICM | DEF_5MIN | 5 MI |
| ICM_MAX_QUE | Maximum limit for allowed entries in request queue (server) | KPI value represents the maximum limit of how many entries can be in the request queue at one moment. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_ICM | DEF_5MIN | 5 MI |
| ICM_MAX_THR | Maximum limit for allowed threads (server) | Maximum allowed threads on the application server at one time. Application server may sometimes override the limit if it needs to. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_ICM | DEF_5MIN | 5 MI |
| ICM_PEAK_CONN | All-time peak connections (server) | KPI value represents the maximum connections set on the application server at a specific time. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_ICM | DEF_5MIN | 5 MI |
| ICM_PEAK_QUE | All-time peak entries in request queue (server) | KPI value represents all-time maximum entries in the queue for one given moment. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_ICM | DEF_5MIN | 5 MI |
| ICM_PEAK_THR | All-time peak threads (server) | All-time peak thread count. Specifies the all-time maximum number of threads that were active at the same time. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_ICM | DEF_5MIN | 5 MI |
| ICM_RUNN_THR | Number of running threads (server) | KPI value represents the number of threads, that is in the "Running" state on the application server. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_ICM | DEF_5MIN | 5 MI |
| ICM_RUN_THR_P | Percentage of used running threads (server) | KPI value represents the percentage of threads used (RUNNING state) at a given point of time (running threads/all threads). If this value is f.e. 20% - that means rest (80%) are threads in IDLE state or occasionally in UNKNOWN if SAP can't determine its state. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_ICM | DEF_5MIN | 5 MI |
| ICM_UNK_THR | Number of threads in an unknown state (server) | KPI value represents the number of threads that are currently in the "Unknown" state on the application server (in case of some error or unknown cause). | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_ICM | DEF_5MIN | 5 MI |
| ICM_USED_CONN_P | Percentage of used connections (server) | KPI value represents the percentage of connections used (current connections/max allowed connections). Application servers may have a large number of connections allowed and only a few of them used - values below 1% of the usage are reported as 0%. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_ICM | DEF_5MIN | 5 MI |
| ICM_USED_QUE_P | Percentage of used request queues (server) | KPI value represents the percentage of used queues (current entries/max allowed entries). | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_ICM | DEF_5MIN | 5 MI |
| ICM_USED_THR_P | Percentage of used available threads (server) | KPI value represents the percentage of how many threads are available at one time compared to the maximum allowed threads on the application server. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_ICM | DEF_5MIN | 5 MI |
| IDOC_I_PROC_AVG | Average time of successful inbound IDoc processing (50-53) | IDOC | SYS | only application server | Remote system | /DVD/MON_IDOC_CL_COL_EDIDC | IDOC_1HOUR | 1 HO | |
| IDOC_IN_ERRORS | Number of Errors in Inbound iDocs Processing | List of iDoc Inbound statuses which indicates an error and are counted to KPI: 51 Posting error 52 Posting error 54 Error during formal application check 56 IDOC with error added 60 Syntax error 61 Processing despite syntax error 63 Error passing IDOC to application 65 ALE error | IDOC | SYS | only application server | Remote system | /DVD/MON_IDOC_CL_COL_EDIDC | IDOC_1HOUR | 1 HO |
| IDOC_INBOUND_C | Total count of inbound IDocs for the last snapshot | IDOC | SYS | only application server | Remote system | /DVD/MON_IDOC_CL_COL_EDIDC | IDOC_1HOUR | 1 HO | |
| IDOC_O_PROC_AVG | Average time of successful outbound IDoc processing (01-30) | IDOC | SYS | only application server | Remote system | /DVD/MON_IDOC_CL_COL_EDIDC | IDOC_1HOUR | 1 HO | |
| IDOC_O_TRANS_AVG | Average time of successful transmission (03->12) | IDOC | SYS | only application server | Remote system | /DVD/MON_IDOC_CL_COL_EDIDC | IDOC_1HOUR | 1 HO | |
| IDOC_OUT_ERRORS | Number of Errors in Outbound iDocs processing | List of Outbound iDoc statuses that indicate an error and are counted to KPI: 02 Error passing data to port 04 Control information of EDI subsystem 05 Translation 07 Syntax check 09 Interchange handling 11 Dispatch 15 Interchange acknowledgment negative 17 Functional acknowledgment negative 20 Triggering EDI subsystem 23 Retransmission 25 Processing despite syntax error 27 ALE error 34 Error in control record of IDOC 36 Timeout error; electronic signature not performed 37 IDOC added incorrectly 40 Application document not created in the target system | IDOC | SYS | only application server | Remote system | /DVD/MON_IDOC_CL_COL_EDIDC | IDOC_1HOUR | 1 HO |
| IDOC_OUTBOUND_C | Total count of outbound IDocs for the last snapshot | IDOC | SYS | only application server | Remote system | /DVD/MON_IDOC_CL_COL_EDIDC | IDOC_1HOUR | 1 HO | |
| LAN_ERROR_IN | Network errors In | This KPI counts the number of network errors In. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_1MIN | 1 MI |
| LAN_ERROR_OUT | Network errors Out | This KPI counts the number of network errors Out. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_1MIN | 1 MI |
| LAN_PACKETS_IN | Network packets In | This KPI counts the number of network packets In. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_1MIN | 1 MI |
| LAN_PACKETS_OUT | Network packets Out | This KPI counts the number of network packets Out. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_1MIN | 1 MI |
| MEM_FREE | Memory free (server) | This KPI is free memory on the server. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_5MIN | 5 MI |
| MEM_FREE_SUM | Total free memory in the system (all servers) | This KPI is total free memory in the system on all servers. | OS | SYS | only application server | Central system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_5MIN | 5 MI |
| MEM_PHYS | Physical memory available (server) | This KPI is available in physical memory on the server. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_1DAY | 1 DA |
| MEM_USED_P | Memory used (server) | This KPI is used memory on the server. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_5MIN | 5 MI |
| NR_MAX_DIFF | Maximum from incremental diffrence of all number ranges | Maximum difference found in single monitored number range. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_NUM_RANGE | DEF_1DAY | 1 DA |
| NR_MAX_SPEED | Maximum from incremental speed of number ranges | Maximum speed found in single monitored number range. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_NUM_RANGE | DEF_1DAY | 1 DA |
| NR_OVER_THR | Number of number ranges which are over threshold | Count of all number ranges that are over threshold. Does not matter if it is speed, difference or percentage threshold. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_NUM_RANGE | DEF_1DAY | 1 DA |
| NR_TOTAL_DIFF | Sum of all incremental differences of number ranges | Differences of all monitored number ranges summed into one value. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_NUM_RANGE | DEF_1DAY | 1 DA |
| NR_MAX_SPEED | Sum of all speeds of monitored number ranges | Total speed of all monitored number ranges. This value represents how fast are numbers assigned from number ranges by day. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_NUM_RANGE | DEF_1DAY | 1 DA |
| PAGE_IN | Kb paged in/s | Page IN from memory per hour. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_1MIN | 1 MI |
| PAGE_IN_P | Page IN from memory per hour | The memory utilization statistics are important to ensure that system performance is running smoothly. This KPI displays the number of pages per hour. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_1MIN | 1 MI |
| PAGE_OUT | Kb paged out/s | When not null, it indicates that the system is swapping. CCMS calculates page out in kb by sec. The value is converted per hour (multiplied by 3600) then divided by the total physical memory available on the hardware to calculate the value in percentage. Values are captured for the database and for all application servers. However, the chart will display only the worst value. You can see page out in kb per sec in SAP with OS07. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_1MIN | 1 MI |
| PAGE_OUT_P | Page OUT from memory per hour | The memory utilization statistics are important to ensure that system performance is running smoothly. This KPI displays the number of pages out per hour. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_1MIN | 1 MI |
| PARAM_CHANGED | Number of changed system profile parameters | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_PARAM | DEF_1DAY | 1 DA | |
| RFC_CIF_IN_15 | tRFCqIN number of entries Queue CIF older than 15 minutes | During the transfer of data between two SAP systems, errors can occur that lead to faulty queue entries. Faulty queue entries need to be rectified as soon as possible before they lead to serialization effects. To do this, you have to be able to display the contents of the queues in such a way the object that caused the error can be determined as quickly as possible and any necessary changes can be made. CIF queue display enables you to do this. tRFCqIN is a standard SAP Table that is used to store tRFC Queue Description (Inbound Queue) information. The relevant SAP transaction for viewing this information is SE11 or SE80. The viewing data contained in this database table via these transactions or alternatively use transaction SE16. This KPI shows tRFCqIN number of entries Queue CIF older than 15 minutes. | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_RFCQ | DEF_1HOUR | 1 HO |
| RFC_CIF_OUT_15 | tRFCqOUT number of entries Queue CIF older than 15 minutes | During the transfer of data between two SAP systems, errors can occur that lead to faulty queue entries. Faulty queue entries need to be rectified as soon as possible before they lead to serialization effects. To do this, you have to be able to display the contents of the queues in such a way the object that caused the error can be determined as quickly as possible and any necessary changes can be made. CIF queue display enables you to do this. tRFCqOUT is a standard SAP Table that is used to store tRFC Queue Description (Outbound Queue) information. The relevant SAP transaction for viewing this information is SE11 or SE80. The viewing data contained in this database table via these transactions or alternatively use transaction SE16. This KPI shows tRFCqOUT number of entries Queue CIF older than 15 minutes. | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_RFCQ | DEF_1HOUR | 1 HO |
| RFC_IN_AUTHERR | Number of failed RFC tests - RFC check with | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_RFC | 1 HO | ||
| RFC_IN_CON_ERR | Number of failed RFC tests - RFC check without | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_RFC | 1 HO | ||
| RFC_IN_PINGERR | Number of failed RFC tests - ping server IP | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_RFC | 1 HO | ||
| ROLL_USED_P | Roll area used | In the Roll area is stored the user context data, such as user authorizations, Set/Get parameters, pointers to active programs, and defaults. The remaining portion of the roll area is used when the system can no longer allocate Extended Memory, either because Extended Memory is full or because the user quota has been reached. This KPI is the amount of Roll area used. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_BUFF | DEF_5MIN | 5 MI |
| SERVER_IS_DOWN | Server is down (true = 1 / false = 0 ) | Checks the accessibility of the SAP instance running on the server. | OS | SER | any server | Central system | DEF_1MIN | 1 MI | |
| SERVER_RFC_FAIL | Server unreachable via RFC (true = 1 / false = 0) | This KPI is similar to the SERVER_IS_DOWN KPI, but it checks the server accessibility from the OS level perspective. | SAPSYS | SER | any server | Central system | DEF_1MIN | 1 MI | |
| SLG_DEBUG | Number of changes in debug mode | GRC | SYS | any server | Remote system | /DVD/MON_GRC_CL_COL_SYSLOG | DEF_1HOUR | 1 HO | |
| SLG_KERNEL | Number of activated C-calls | GRC | SYS | any server | Remote system | /DVD/MON_GRC_CL_COL_SYSLOG | DEF_1HOUR | 1 HO | |
| SSL_CERT_EXP | Number of expiring certificates | Total number of currently expiring/expired SSL certificates across STRUST identities. Certificate is marked as expiring if it has less than 10% of lifetime left and at the same time expiring in less days than defined by parameter (default 30 days). | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_SSL_CERT | DEF_1DAY | 1 DA |
| STAT_DIALOG_AVG | Average System Response Time for Users | Average time between the time at which a dialog process sends a request to a dispatcher work process and the time at which the dialog is complete and the data is transferred to the presentation layer. The response time does not include the time for transferring the data from the SAP front end to the application server. Networks with bad performance can therefore have larger subjective response times. The transfer time is included in the GUI time and the front end network time. Average system response time is usually a time around 1 second(dialog) < 1 second (update). This KPI shows this time, which is adequate for users. | STAT | SYS | any server | Remote system | /DVD/MON_STAT_CL_COL_MODULES | STAT_5MIN | 5 MI |
| STAT_DIALOG_TOT | Total System Response Time for Users | The response time of a transaction step is the difference between the time when the request arrives in the R/3 system and the time when processing in the R/3 system is complete. Total system response time for users is measured by this KPI. | STAT | SYS | any server | Remote system | /DVD/MON_STAT_CL_COL_MODULES | STAT_5MIN | 5 MI |
| STAT_M_RESP_BC | [BC] Response time from Basis Components | The SAP BC (Basis Components) is the root of the SAP Applications ERP software. It provides the runtime environment for the rest of the R/3 Applications. It ensures that applications are optimally integrated into the system environment. The SAP Basis Components contains powerful tools such as CCMS (Computing Center Management System) for easy system administration. Response time from Basis Components is measured by this KPI. | STAT | SYS | any server | Remote system | /DVD/MON_STAT_CL_COL_MODULES | STAT_1HOUR | 1 HO |
| STAT_M_RESP_BW | [BW] Response time from SAP Business Inf. Warehouse | As a core component of SAP NetWeaver, the SAP Business Information Warehouse (SAP BW) provides data warehousing functionality, a business intelligence platform, and a suite of business intelligence tools that enable businesses to attain these goals. Relevant business information from productive SAP applications and all external data sources can be integrated, transformed, and consolidated in SAP BW with the toolset provided. SAP BW provides flexible reporting and analysis tools to support you in evaluating and interpreting data, as well as facilitating its distribution. Businesses are able to make well-founded decisions and determine target-orientated activities on the basis of this analysis. This KPI shows response time from SAP Business Inf. Warehouse. | STAT | SYS | any server | Remote system | /DVD/MON_STAT_CL_COL_MODULES | STAT_1HOUR | 1 HO |
| STAT_M_RESP_XXXX | Total response time from undefined components | The response time of a transaction step is the difference between the time when the request arrives in the R/3 system and the time when processing in the R/3 system is complete. This KPI shows total response time from components, which are undefined. | STAT | SYS | any server | Remote system | /DVD/MON_STAT_CL_COL_MODULES | STAT_1HOUR | 1 HO |
| STAT_M_TCNT_BC | [BC] Number of trans. from Basis Components | The SAP BC (Basis Components) is the root of the SAP Applications ERP software. It provides the runtime environment for the rest of the R/3 Applications. It ensures that applications are optimally integrated in the system environment. The SAP Basis Components contains powerful tools such as CCMS (Computing Center Management System) for easy system administration. Number of trans. from Basis Components is processed by this KPI. | STAT | SYS | any server | Remote system | /DVD/MON_STAT_CL_COL_MODULES | STAT_1HOUR | 1 HO |
| STAT_M_TCNT_BW | [BW] Number of trans. from SAP Business Inf. Warehouse | As a core component of SAP NetWeaver, the SAP Business Information Warehouse (SAP BW) provides the data warehousing functionality, a business intelligence platform, and a suite of business intelligence tools that enable businesses to attain these goals. Relevant business information from productive SAP applications and all external data sources can be integrated, transformed, and consolidated in SAP BW with the toolset provided. SAP BW provides flexible reporting and analysis tools to support you in evaluating and interpreting data, as well as facilitating its distribution. Businesses are able to make well-founded decisions and determine target-orientated activities on the basis of this analysis. Number of trans. from SAP Business Inf. Warehouse is processed by this KPI. | STAT | SYS | any server | Remote system | /DVD/MON_STAT_CL_COL_MODULES | STAT_1HOUR | 1 HO |
| STAT_M_TCNT_XXXX | Number of transactions from undefined components | Number of transactions from undefined components is displayed by this KPI. | STAT | SYS | any server | Remote system | /DVD/MON_STAT_CL_COL_MODULES | STAT_1HOUR | 1 HO |
| STAT_RSA1_AVG | Average runtime of RSA1 | RSA1 - Modeling - DW Workbench. Average runtime of RSA1 is displayed by this KPI. | STAT | SYS | any server | Remote system | /DVD/MON_STAT_CL_COL_MODULES | STAT_5MIN | 5 MI |
| STAT_SE16_AVG | Average Response Time of Transaction SE16 | SE16 - Data Browser. Average response time of the transaction is processed by KPI with the name STAT_SE16_AVG. | STAT | SYS | any server | Remote system | /DVD/MON_STAT_CL_COL_MODULES | STAT_5MIN | 5 MI |
| STAT_SE16_CNT | Number of SE16 Transaction starts | SE16 - Data Browser. Number of SE16 Transactions starts is displayed by this KPI. | STAT | SYS | any server | Remote system | /DVD/MON_STAT_CL_COL_MODULES | STAT_5MIN | 5 MI |
| STAT_SE16_TTL | Response Time of Transaction SE16 | SE16 - Data Browser. This KPI shows the response time of transaction SE16. | STAT | SYS | any server | Remote system | /DVD/MON_STAT_CL_COL_MODULES | STAT_5MIN | 5 MI |
| STAT_SE38_RESP | Response Time of Transaction SE38 | SE38 - ABAP Editor. This KPI shows the response time of transaction SE38. | STAT | SYS | any server | Remote system | /DVD/MON_STAT_CL_COL_MODULES | STAT_5MIN | 5 MI |
| STAT_SE38_RUN | Average Runtime of reports running via SE38 | SE38 - ABAP Editor. Average Runtime of reports running via transaction SE38. | STAT | SYS | any server | Remote system | /DVD/MON_STAT_CL_COL_MODULES | STAT_5MIN | 5 MI |
| SWAP_CONF | Swap configured | This KPI is the amount of configured swap space. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_1DAY | 1 DA |
| SWAP_DELTA | Delta between previous and current used swap | This is the difference between the two snapshots of Free Swap in the percentage of total swap. This is more accurate than "Page Out %" which is a snapshot when FM runs. It’s possible that the system was paging 1 minute before the FM runs and the page out returns 0. But it takes some time to recover from paging and delta swap will show a value. 0.5% of delta swap is already too much. | OS | SER | only application server | Central system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_1MIN | 1 MI |
| SWAP_DELTA_P | Delta between previous and current used swap | This is the difference between 2 snapshots of used swap in the percentage of total swap. This is more accurate than "Page Out %" which is a snapshot when the collector runs. It’s possible that the system was paging 1 minute before the collector runs and page out returns 0. It takes some time then to recover from paging and delta swap will show a value. | OS | SER | only application server | Central system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_1MIN | 1 MI |
| SWAP_DELTA_PMAX | Delta between swap (max all servers) | Swap used is calculated by CCMS, see transaction ST06N. This KPI is the delta of the swap used between the last 2 snapshots, calculated in percentage of a swap area. | OS | SYS | only application server | Central system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_1MIN | 1 MI |
| SWAP_FREE | Free swap space | Free Swap in the percentage of total swap. When it reaches zero, the instance is dead. When going down, it means the system is swapping. But swaps are more accurate in the indicator "Page Out %", as a free swap is a HWM. Values are captured for all servers (AS and BD), the minimum value is displayed in the chart. You can see this with OS07. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_5MIN | 5 MI |
| SWAP_USED | Used swap space | This KPI is the amount of used swap space - in kB. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_5MIN | 5 MI |
| SWAP_USED_P | Used swap space | KPI calculates percentages of used swap space by substituting actual value SWAP_FREE from SWAP_CONF. | OS | SER | only application server | Remote system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_5MIN | 5 MI |
| SWAP_USED_PMAX | Used swap (max all servers) | Swap used is calculated by CCMS, see transaction ST06N. This KPI is the max swap used in the percentage of swap area for all servers monitored for this SID. | OS | SYS | only application server | Central system | /DVD/MON_CL_COL_MEM_CPU_LAN | DEF_5MIN | 5 MI |
| SYSTEM_IS_DOWN | System is not responding (true = 1 / false = 0 ) | Special KPI hardcoded in CanaryCode is without collector, value 1 if SID is not responding (RFC call not possible to satellite system). Can be used for alerting. | SAPSYS | SYS | any server | Central system | DEF_1MIN | 1 MI | |
| UPD_REQ_CANCEL | Update requests canceled | An update request, or update record, describes data changes determined in SAP LUW. These changes should be made completely, or not all (this means, in a database LUW). This refers only to V1 updates. V2 updates are triggered once the V1 update is complete and are processed in a separate database LUW. An update request is identified by its update key. An update request consists of an update header, V1 modules (or components), a V2 module, and a collective run module. When the update requests are canceled, this situation is displayed by this KPI. | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_UPD_REQ | DEF_1HOUR | 1 HO |
| UPD_REQ_TOBEUPD | Update requests to be updated | An update request, or update record, describes data changes determined in SAP LUW. These changes should be made completely, or not all (this means, in a database LUW). This refers only to V1 updates. V2 updates are triggered once the V1 update is complete and are processed in a separate database LUW. An update request is identified by its update key. An update request consists of an update header, V1 modules(or components), V2 module, and collective run module. This KPI shows the situation when update requests to be updated. | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_UPD_REQ | DEF_1HOUR | 1 HO |
| USER_CNT | Number of active users | This KPI is the number of active users. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_USER_INFO | DEF_5MIN | 5 MI |
| USER_CNT_SER | Number of active users (server) | SAPSYS | SER | only application server | Remote system | /DVD/MON_CL_COL_USER_INFO | DEF_5MIN | 5 MI | |
| USER_EXT_MOD | Number of external modes | This KPI is the number of external modes. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_USER_INFO | DEF_5MIN | 5 MI |
| USER_EXT_MOD_SER | Number of external modes(server) | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_USER_INFO | |||
| USER_GUI_CNT | Number of interactive users | This KPI is the number of interactive users. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_USER_INFO | DEF_5MIN | 5 MI |
| USER_GUI_CNT_SER | Number of interactive users(server) | /DVD/MON_CL_COL_USER_INFO | |||||||
| USER_INT_MOD | Number of internal modes | This KPI is the number of active users. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_USER_INFO | DEF_5MIN | 5 MI |
| USER_INT_MOD_SER | Number of internal modes(server) | /DVD/MON_CL_COL_USER_INFO | |||||||
| USER_RFC_CNT | Number of RFC-users | This KPI is the number of RFC users. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_USER_INFO | DEF_5MIN | 5 MI |
| USER_RFC_CNT_SER | Number of RFC-users (server) | SAPSYS | SER | only application server | Remote system | /DVD/MON_CL_COL_USER_INFO | |||
| USR_INIT | Number of users never logged in | The number of SAP users with never logged in. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_USR | DEF_1DAY | 1 DA |
| USR_INIT_PW | Number of users with initial password | The number of SAP users with initial passwords and logged time. Indicating that password is probably reset. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_USR | DEF_1DAY | 1 DA |
| USR_INVALID | Number of expired users | The number of SAP users which past their validity date. Only applicable to users created with specified VALID_TO date. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_USR | DEF_1DAY | 1 DA |
| USR_LOCK | Number of locked users | The number of locked SAP users on a system, irrespective of the lock reason. For example, they can be locked by administrator, too many failed login attempts or other reasons. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_USR | DEF_1DAY | 1 DA |
| USR_OLD | Number of users with password age above preset threshold | "The number of SAP users that have a password older than configured by parameter OLD_PASSWORD. By default, it is set to 180 days, but can be changed in Collector settings under ""Parameters"" tree. Users with NULL passwords are excluded." | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_USR | DEF_1DAY | 1 DA |
| USR_SAPS_DEL | Number of deleted SAP* users on system (across all clients) | The number of non-existing SAP* users on a system (across all clients). Removed SAP* users are a potential security risk, as they can be used as backdoor login. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_USR | DEF_1DAY | 1 DA |
| USR_SAPS_KER | Security risk with SAP* user | A Flag that indicates an imminent security risk on a system. Value 1 is returned, if the SAP* user is removed on any client and a kernel login using SAP* is permitted. Related is profile parameter login/no_automatic_user_sapstar. | SAPSYS | SYS | any server | Remote system | /DVD/MON_CL_COL_USR | DEF_1DAY | 1 DA |
| WDISP_CONN_USED_CURR | Number of currently used connection | Number of currently used connections in SAP Web Dispatcher Monitor (Web Dispatcher Administration Interface). | WDISP | SYS | any server | Remote system | /DVD/MON_WDISP_CL_COLLECTOR | WDISP_5MIN | 5 MI |
| WDISP_CONN_USED_MAX | Maximum number of used connection | Maximum number of used connections in SAP Web Dispatcher Monitor (Web Dispatcher Administration Interface). | WDISP | SYS | any server | Remote system | /DVD/MON_WDISP_CL_COLLECTOR | WDISP_5MIN | 5 MI |
| WDISP_IS_RUNNING | Is Admin Web Interface running? | This KPI represents whether the Administration Interface for Web Dispatcher is running or not ("1-running", "0-not running). | WDISP | SYS | any server | Remote system | /DVD/MON_WDISP_CL_COLLECTOR | WDISP_5MIN | 5 MI |
| WDISP_QUEUE_USED_CURR | Number of currently used Queue entries | Number of currently used Queue entries in SAP Web Dispatcher Monitor (Web Dispatcher Administration Interface). | WDISP | SYS | any server | Remote system | /DVD/MON_WDISP_CL_COLLECTOR | WDISP_5MIN | 5 MI |
| WDISP_QUEUE_USED_MAX | Maximum number for used Queue entries | Maximum number of used Queue entries in SAP Web Dispatcher Monitor (Web Dispatcher Administration Interface). | WDISP | SYS | any server | Remote system | /DVD/MON_WDISP_CL_COLLECTOR | WDISP_5MIN | 5 MI |
| WDISP_STATUS | Web Admin Interface Status (1-running, 2-maintenance) | This KPI represents the status in which is the Administration Interface for Web Dispatcher ("1-running", "2-maintenance"). If the Administration Interface for Web Dispatcher is not running, this KPI value is not collected. | WDISP | SYS | any server | Remote system | /DVD/MON_WDISP_CL_COLLECTOR | WDISP_5MIN | 5 MI |
| WDISP_THRD_CREATED_CURR | Number of currently created threads | Number of currently created threads in SAP Web Dispatcher Monitor (Web Dispatcher Administration Interface). | WDISP | SYS | any server | Remote system | /DVD/MON_WDISP_CL_COLLECTOR | WDISP_5MIN | 5 MI |
| WDISP_THRD_CREATED_MAX | Maximum number for created threads | Maximum number for created threads in SAP Web Dispatcher Monitor (Web Dispatcher Administration Interface). | WDISP | SYS | any server | Remote system | /DVD/MON_WDISP_CL_COLLECTOR | WDISP_5MIN | 5 MI |
| WDISP_THRD_IDLE | Number of threads in Idle state | Number of threads with status 'idle' in SAP Web Dispatcher Monitor (Web Dispatcher Administration Interface). | WDISP | SYS | any server | Remote system | /DVD/MON_WDISP_CL_COLLECTOR | WDISP_5MIN | 5 MI |
| WDISP_THRD_RUNNING | Number of currently running threads | Number of threads with status 'running' in SAP Web Dispatcher Monitor (Web Dispatcher Administration Interface). | WDISP | SYS | any server | Remote system | /DVD/MON_WDISP_CL_COLLECTOR | WDISP_5MIN | 5 MI |
| WP_BTC_CONF | Number of BTC configured (server) | Number of free BTC WP (for the instance) divided by a total number of BTC WP. When it reaches zero, batch jobs are queuing. You can see total / free BTC WP in SAP with transaction SM66. Some charts display Used BTC % = 100 % - Free BTC %. | SAPSYS | SER | only application server | Remote system | /DVD/MON_CL_COL_GET_WP | DEF_1HOUR | 1 HO |
| WP_BTC_CONF_SUM | Number of BTC configured (all servers) | Number of free BTC WP (for the instance) divided by a total number of BTC WP. When it reaches zero, batch jobs are queuing. You can see total / free BTC WP in SAP with transaction SM66. | SAPSYS | SYS | only application server | Central system | /DVD/MON_CL_COL_GET_WP | DEF_1HOUR | 1 HO |
| WP_BTC_USED | Number of used BTC (server) | This KPI counts the number of used BTC work processes on the server. | SAPSYS | SER | only application server | Remote system | /DVD/MON_CL_COL_GET_WP | DEF_5MIN | 5 MI |
| WP_BTC_USED_MAX | Usage of BTC (max all servers) | KPI value determines the number of BTC work processes (WP) of the server with the highest amount of BTC WP - returns a value of the busiest server. | SAPSYS | SYS | only application server | Central system | /DVD/MON_CL_COL_GET_WP | DEF_5MIN | 5 MI |
| WP_BTC_USED_P | Usage of BTC (server) | Number of used BTC WP (for the instance) divided by a total number of BTC WP. When it reaches 100%, batch jobs are queuing. You can see total / free BTC WP in SAP with transaction SM66. | SAPSYS | SER | only application server | Remote system | /DVD/MON_CL_COL_GET_WP | DEF_5MIN | 5 MI |
| WP_BTC_USED_S_P | Number of used BTC (all servers) | For the WP info, we calculate the number of batch work processes (BTC WP) currently used for the system (SID), in the percentage of a total number of BTC WP configured for this system. It’s not looking at a specific application server but calculated for the sum of all application servers. | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_GET_WP | DEF_5MIN | 5 MI |
| WP_BTC_USED_SUM | Usage of BTC (all servers) | Count the number of used DIA work processes captured in SM66 (saved in /DVD/MON_WPINFO on the central instance), for all application servers. | SAPSYS | SYS | only application server | Central system | /DVD/MON_CL_COL_GET_WP | DEF_5MIN | 5 MI |
| WP_COMMIT | Number of WP in COMMIT state | This KPI counts the number of WP in the COMMIT state captured in SM66 (saved in /DVD/MON_WPINFO on the central instance). | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_GET_WP | DEF_5MIN | 5 MI |
| WP_DIA_CONF | Number of DIA configured (server) | This KPI is the number of DIA work processes configured on the server. | SAPSYS | SER | only application server | Remote system | /DVD/MON_CL_COL_GET_WP | DEF_1HOUR | 1 HO |
| WP_DIA_CONF_SUM | Number of DIA configured (all servers) | This KPI is the number of DIA work processes configured on all servers. | SAPSYS | SYS | only application server | Central system | /DVD/MON_CL_COL_GET_WP | DEF_1HOUR | 1 HO |
| WP_DIA_LONGR | Longest running DIA WP (server) | This KPI is longest running DIA work process - in seconds. | SAPSYS | SER | only application server | Remote system | /DVD/MON_CL_COL_GET_WP | DEF_1MIN | 1 MI |
| WP_DIA_LONGR_MAX | Longest running DIA WP (max all servers) | Max value of runtime of DIA WP captured in SM66 (saved in /DVD/MON_WPINFO on the central instance). | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_GET_WP | DEF_1MIN | 1 MI |
| WP_DIA_NBR_AT | Number of long running DIA WP (server) | Adjusted value of "Average response DIA (sec)" excluding DIA WP from users RFC-* and DIA WP with a duration greater than timeout, so the indicator adjusted will display only when several users have a response time of several minutes. | SAPSYS | SER | only application server | Remote system | /DVD/MON_CL_COL_GET_WP | DEF_1MIN | 1 MI |
| WP_DIA_NBR_ATDU | Number of long running DIA WP for Dialog User (server) | This KPI is dependent on parameters configured in the configure file, specifically the parameter DIA_THRESHOLD_DIALOG_USER. It returns a number of dialog WP which duration is longer than the predetermined value by parameter. The default value is 120 seconds. This value can be changed in the collector parameters setup. | SAPSYS | SER | only application server | Remote system | /DVD/MON_CL_COL_GET_WP | DEF_1MIN | 1 MI |
| WP_DIA_NBR_ATDUS | Number of long running DIA WP for Dialog User (all servers) | This KPI is dependent on parameters configured in the configure file, specifically the parameter DIA_THRESHOLD_DIALOG_USER. It counts the number of all dialog WP from all servers which duration is longer than the predetermined value by parameter. The default value is 120 seconds. This value can be changed in the collector parameters setup. | SAPSYS | SYS | only application server | Central system | /DVD/MON_CL_COL_GET_WP | DEF_1MIN | 1 MI |
| WP_DIA_NBR_ATSUM | Number of long running DIA WP (all servers) | A snapshot of SM66 is taken every 5 minutes (saved in /DVD/MON_WPINFO on the central instance). This KPI is the number of DIA WP running for more than 120 sec that is in the captured SM66. The threshold (120 sec) can be changed in the parameters of the collector /DVD/MON_CL_COL_GET_WP. | SAPSYS | SYS | only application server | Central system | /DVD/MON_CL_COL_GET_WP | DEF_1MIN | 1 MI |
| WP_DIA_RT_AVG | Avg. runtime of DIA processes (server) | Average response time of dialog WP captured in SM66. The exact value is meaningless, but the trend is important and when increasing, it can show a lock-wait situation or a few WP that are not killed after the timeout. Values are captured for all application servers. The chart displays the average for the instance. | SAPSYS | SER | only application server | Remote system | /DVD/MON_CL_COL_GET_WP | DEF_5MIN | 5 MI |
| WP_DIA_RT_AVG_A | Avg. runtime of DIA processes (all servers) | Average response time of dialog WP captured in SM66. The exact value is meaningless, but the trend is important and when increasing, it can show a lock-wait situation or a few WP that are not killed after the timeout. Values are captured for all application servers. | SAPSYS | SYS | only application server | Central system | /DVD/MON_CL_COL_GET_WP | DEF_5MIN | 5 MI |
| WP_DIA_USED | Number of used DIA (server) | This KPI counts the number of used dialog WP on the server. | SAPSYS | SER | only application server | Remote system | /DVD/MON_CL_COL_GET_WP | DEF_5MIN | 5 MI |
| WP_DIA_USED_MAX | Number of used DIA (max all servers) | Maximum value of a number of DIA WP used per server in the percentage of a total number of DIA WP in the same server. When all DIA is used on an application server, users connected to this server could have a connection issue, even if some DIA WP is available on other application servers. | SAPSYS | SYS | only application server | Central system | /DVD/MON_CL_COL_GET_WP | DEF_5MIN | 5 MI |
| WP_DIA_USED_P | Usage of DIA (server) | Number of free DIA WP (for the instance) divided by a total number of DIA WP. You can see total/free DIA WP in SAP with transaction SM66. When it reaches zero, the server looks frozen for many users. The trend shows if more or less PW is running. To be compared to CPU load: If CPU load increases dramatically and the number of WP is stable, it shows bad behavior, unless CPU load goes above 80%. Some charts display Used DIA% = 100% - Free DIA %. | SAPSYS | SER | only application server | Remote system | /DVD/MON_CL_COL_GET_WP | DEF_5MIN | 5 MI |
| WP_DIA_USED_S_P | Number of used DIA (all servers) | Number of free DIA WP (for the instance) divided by a total number of DIA WP. Work process Info (i.e., SM66) is captured every 5 minutes. For the WP info, we calculate the number of dialog work processes (DIA WP) currently used for the system (SID), in the percentage of a total number of DIA WP configured in this system. I.e., it's not looking at a specific application server but calculated for the sum of all application servers. When it reaches zero, the server looks frozen for many users. The trend shows if more or less PW is running. To be compared to CPU load: If CPU load increases dramatically and the number of WP is stable, it shows bad behavior, unless CPU load goes above 80%. Some charts display Used DIA % = 100 % - Free DIA %. | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_GET_WP | DEF_5MIN | 5 MI |
| WP_DIA_USED_SUM | Usage of DIA (all servers) | Count the number of used DIA work processes captured in SM66 (saved in /DVD/MON_WPINFO on the central instance), for all application servers. | SAPSYS | SYS | only application server | Central system | /DVD/MON_CL_COL_GET_WP | DEF_5MIN | 5 MI |
| WP_MAX_REPORT | Number of WP on the same report (all servers) | Count the number of work processes (DIA or BTC) on the same report captured in SM66 (saved in /DVD/MON_WPINFO on the central instance), for all users. | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_GET_WP | DEF_1MIN | 1 MI |
| WP_MAX_TABLE | Number of WP on the same table (all servers) | Count the number of work processes (DIA or BTC) on the same table name, captured in SM66 (saved in /DVD/MON_WPINFO on the central instance), for all users. | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_GET_WP | DEF_1MIN | 1 MI |
| WP_MAX_USER | Number of WP with the same user (all servers) | Count the number of work processes (DIA or BTC) with the same user captured in SM66 (saved in /DVD/MON_WPINFO on the central instance), for user type ‘A’:Dialog user. | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_GET_WP | DEF_1MIN | 1 MI |
| WP_NRIV | Number of WP accessing number ranges | Count the number of WP captured in SM66 (saved in /DVD/MON_WPINFO on the central instance) showing table = NRIV. | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_GET_WP | DEF_1MIN | 1 MI |
| WP_SAPLSENA | Number of WP calling ENQUEUE | This KPI counts the number of WP running report SAPLSENA in captured SM66 (saved in /DVD/MON_WPINFO on the central instance). Those are processing enqueues. If too many ENQ are raised at the same time, or if the processing of ENQ is slow, we have seen hundreds of WP hanging in SAPLSENA. Eventually, all WP can be used and the complete system will be hanging. When there are many ENQ, the DIA will take longer, see the chart below showing the correlation between the No. of DIA WP running for more than 120 sec and the number of WP in SAPLSENA. | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_GET_WP | DEF_5MIN | 5 MI |
| WP_UP2_CONF | Number of UP2 configured (server) | This KPI is a number of configured work processes for task processing on the server - these tasks are in the update process with the priority V2. | SAPSYS | SER | only application server | Remote system | /DVD/MON_CL_COL_GET_WP | DEF_1DAY | 1 DA |
| WP_UP2_CONF_SUM | Number of UP2 configured (all servers) | This KPI is a number of configured work processes for task processing on all servers - these tasks are in the update process with the priority V2. | SAPSYS | SYS | only application server | Central system | /DVD/MON_CL_COL_GET_WP | DEF_1DAY | 1 DA |
| WP_UP2_USED | Number of used UP2 (server) | UP2 is used for 'statistical' updates (and some RFC signaling). Number of used UP2 WP (for the instance) divided by a total number of UP2 WP. When it reaches 100%, all transactions are stopped. You can see total / free UP2 WP in SAP with transaction SM66. | SAPSYS | SER | only application server | Remote system | /DVD/MON_CL_COL_GET_WP | DEF_5MIN | 5 MI |
| WP_UP2_USED_SUM | Number of used UP2 (all servers) | UP2 is used for 'statistical' updates (and some RFC signaling). Number of used UP2 WP (for the instance) divided by a total number of UP2 WP. When it reaches 100%, all transactions are stopped. You can see total / free UP2 WP in SAP with transaction SM66. | SAPSYS | SYS | only application server | Central system | /DVD/MON_CL_COL_GET_WP | DEF_5MIN | 5 MI |
| WP_UPD_CONF | Number of UPD configured (server) | This KPI is a number of configured work processes for task processing on the server - these tasks are in the update process with the highest priority (V1). | SAPSYS | SER | only application server | Remote system | /DVD/MON_CL_COL_GET_WP | DEF_1DAY | 1 DA |
| WP_UPD_CONF_SUM | Number of UPD configured (all servers) | This KPI is a number of configured work processes for task processing on all servers - these tasks are in the update process with the highest priority (V1). | SAPSYS | SYS | only application server | Central system | /DVD/MON_CL_COL_GET_WP | DEF_1DAY | 1 DA |
| WP_UPD_USED | Number of used UPD (server) | Number of used UPD WP (for the instance) divided by a total number of UPD WP. When it reaches 100%, all transactions are stopped. You can see total / free UPD WP in SAP with transaction SM66. | SAPSYS | SER | only application server | Remote system | /DVD/MON_CL_COL_GET_WP | DEF_5MIN | 5 MI |
| WP_UPD_USED_SUM | Number of used UPD (all servers) | Number of used UPD WP (for the instance) divided by a total number of UPD WP. When it reaches 100%, all transactions are stopped. You can see total / free UPD WP in SAP with transaction SM66. | SAPSYS | SYS | only application server | Central system | /DVD/MON_CL_COL_GET_WP | DEF_5MIN | 5 MI |
| SDTR_ERROR_CNT | Number of all transmission in error | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_SEND_TRANSMIT | DEF_1HOUR | 1 HO | |
| SDTR_TRANSMT_CNT | Number of successfully transmitted mail requests | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_SEND_TRANSMIT | DEF_1HOUR | 1 HO | |
| SDTR_WAITING_CNT | Number of waiting transmissions | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_SEND_TRANSMIT | DEF_1HOUR | 1 HO | |
| USR_STAT_INACT6M | Number of inactive users not logged in in the last 6 months | SAPSYS | SYS | only application server | Remote system | /DVD/MON_CL_COL_USR_STAT | DEF_1DAY | 1 DA | |
| GRC_REF_USR_CNT | Number of used reference users | GRC | SYS | any server | Remote system | /DVD/MON_GRC_CL_COL_REF_USERS | 1 MI | ||
| GRC_SEC_NOTE_CNT | Number of not implemented security notes | SAPSYS | SYS | any server | Remote system | /DVD/MON_GRC_CL_COL_SEC_NOTES | |||
| GRC_AUTH_ALL | Number of users with full authorization (SAP_ALL,SAP_NEW) | GRC | SYS | only application server | Remote system | /DVD/MON_GRC_CL_COL_USR_AUTH | GRC_1DAY | 1 DA | |
| GRC_AUTH_ALL_O_N | Number of NEW users with full authorization(SAP_ALL,SAP_NEW) | GRC | SYS | only application server | Remote system | /DVD/MON_GRC_CL_COL_USR_AUTH | |||
| ORA_LOG_00060 | ORA-00060 - Deadlock detected while waiting for resource | ORACLE | SYS | any server | Remote system | /DVD/MON_ORA_CL_COL_ALERTLOG | ORA_5MIN | 5 MI | |
| ORA_LOG_01578 | ORA-01578 - Data block corrupted | ORACLE | SYS | any server | Remote system | /DVD/MON_ORA_CL_COL_ALERTLOG | ORA_5MIN | 5 MI | |
| ORA_LOG_01653 | ORA-01653 - Unable to extend table *.* by * in tablespace * | ORACLE | SYS | any server | Remote system | /DVD/MON_ORA_CL_COL_ALERTLOG | ORA_5MIN | 5 MI | |
| ORA_LOG_27072 | ORA-27072 - File I/O error | ORACLE | SYS | any server | Remote system | /DVD/MON_ORA_CL_COL_ALERTLOG | ORA_5MIN | 5 MI | |
| ORA_PGA_USED | Oracle: Total PGA memory used | ORACLE | SER | only external server | Remote system | /DVD/MON_ORA_CL_COL_MEM | 5 MI | ||
| ORA_SESS_ALL | Number of Oracle sessions | ORACLE | SYS | any server | Remote system | /DVD/MON_ORA_CL_COL_SESSION | 5 MI | ||
| ORA_SESS_INST | Oracle sessions per instance | ORACLE | SER | only external server | Remote system | /DVD/MON_ORA_CL_COL_SESSION | 5 MI | ||
| ORA_TS_SIZEP | DB used size (table spaces) | ORACLE | SYS | any server | Remote system | /DVD/MON_ORA_CL_COL_SPACE | 5 MI | ||
| ORA_LOG_30036 | ORA-30036 - Unable to extend segm. by * in undo tab.sp. '*' | ORACLE | SYS | any server | Remote system | /DVD/MON_ORA_CL_COL_ALERTLOG | ORA_5MIN | 5 MI | |
| OS_RUN_PS_COUNT | Get number of running processes on OS | Get count of running processes on OS. Example of KPI for collector /DVD/MON_CL_COL_SYS_CMD, that can run any OS command. | OS | SYS | only application server | Remote system | /DVD/MON_CL_COL_SYS_CMD |