(DI-2208) Collector for BW Query Runtimes
This collector monitors the state of BW queries and reports queries that ends up in error or are too long-running /DVD/MON_BW_CL_COL_QUERY_RT.
Default KPIs delivered with this collector
The following default KPIs are delivered with this collector:
KPI name | Description | Unit | Detail table |
---|---|---|---|
BW_QUERY_ERROR | BW: Number of erroneous Queries | Number | Yes |
BW_QUERY_LONG_RUN | BW: Number of long-running Queries | Number | Yes |
BW_QUERY_RUNTIME | BW: Number of executed Queries | Number | Yes |
Parameters
The following parameters are used for this collector:
Parameter name | Description |
---|---|
TIME_PERIOD_IN_SECS | Default 3600 seconds (1 hour). Defines how far back in time should query data be processed. |
Detail table
The collector provides detail tables BW Queries Runtime Collector. The technical name of the detail table is /DVD/MON_BW_PCE. It contains queries that are too long-running or are in an error state.
Technical name | Description |
---|---|
QUERY_NAME | Name (ID) of a reporting component |
STARTTIME | BW Query Start Timestamp |
SESSIONUID | Session ID |
STEPUID | Step ID |
STEPTP | OLAP Statistics: Step Type (ODBO, BEX, etc.) |
USER_NAME | User Name |
USER_GROUP | User group in user master maintenance |
INFOPROVIDER | InfoProvider |
INFOPROVIDER_TEXT | Long description |
INFOAREA | InfoArea |
INFOAREA_TEXT | Long description |
DATA_MANAGER | BW Query: Data Manager Runtime |
OLAPS_AUTH | BW Query: OLAP Authorization Runtime |
OLAPS_CACHE | BW Query: OLAP Cache Runtime |
OLAPS_OLAP | BW Query: OLAP Runtime |
TOTAL_RUNTIME | BW Query: Total Runtime |
DBTRANS | Total Number of Transported Records |
DBSEL | Total Number of Read Records |
WHERE_CLAUSE | WHERE clause for the filter of the BW query |
STATUS | Query Status |
ERROR_TEXT | Error Text |