(DI-2205) Collector for BW Statistics
- SNP
- Marian Vidra
The collector for BW statistics is /DVD/MON_BW_CL_COL_RSDDSTATS.
It collects statistical KPIs about BW. The KPIs are defined through the KPI definition and the Input table /DVD/MON_BWSTDEF, which sets an extended KPI definition with the following fields:
KPI name | The same technical name as in the KPI definition |
Event ID | OLAP Statistics Event |
User name | User name |
Step type | OLAP Statistics: Step Type |
InfoProvider | InfoProvider |
Object name | OLAP Statistic Object Name |
DBTRANS | Max No. of Transferred Records |
| Function | AVG( RUNTIME ) MAX( EVTIME ) COUINT( * ) |
| MIN_HINT | Minimum number of steps to calculate the value |
| DECIMALS | Number of decimals displayed by the KPI value |
Change by user | Last change by user [automatically filled] |
Change date | Last change date [automatically filled] |
The collector provides also a detailed output in a Detail table for the KPIs assigned to this collector. The Detail table BW Failed query on DM - /DVD/MON_BWMISDM contains the following fields:
Timestamp |
System ID |
BW Statistics: Day |
BW Statistics Time |
STEPUID |
Internal ID of a Query Runtime Object |
Internal Type of Query Runtime Object |
OLAP Statistics Object Name |
| User Name |
The following KPIs are provided in the CrystalBridge® Monitoring delivery with this collector:
KPI name | Description | Unit |
BW_9000DMMISS | Number of queries failing on DM (BWA, DB, HANA) | Count |
BW_SSQL_ALLNO | SQL-Total number of subqueries | Count |
BW_SSQL_ALLTIM | SQL-Total time spent on subqueries | |
BW_SSQL_SQAR | SQL-Average runtime of small subqueries | |
BW_SSQL_SQLO | SQL-No of small subqueries long-running (eg > 10 SEC) | Count |
BW_SSQL_SQNO | SQL-No of small subqueries | Count |
BW_SUBQ_ALLNO | nonSQL-Total number of subqueries (BWA or HANA) | Count |
BW_SUBQ_ALLTIM | nonSQL-Total time spent on subqueries (BWA or HANA) | |
BW_SUBQ_SQAR | nonSQL-Average runtime of small subqueries (BWA or HANA) | |
BW_SUBQ_SQLO | nonSQL-No of small subqueries long-running (e.g.>10SEC) e.g. BWA | Count |
BW_SUBQ_SQNO | nonSQL-No of small subqueries (BWA or HANA) | Count |
All default BW statistic KPIs have the prefix BW_*