(DI-1911) Collector for BW Statistics

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 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 Statistik Object Name

User Name

The following KPIs are provided in the Insights 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 (eg>10SEC) eg BWA	count
BW_SUBQ_SQNO	nonSQL-No of small subqueries (BWA or HANA)	count

All default BW statistic KPIs have the prefix BW_*