(DI-1805) System Health

Owned by SNP
Apr 30, 2018
3 min read

The worst runtime queries

The visualization shows the worst and also best query executions runtimes per some analysed period per day. For each day maximum of 10 worst query executions are captured. 

Query worst runtime analysis chart


The user can filter data and also switch to the table view for more detailed information where data can be downloaded into a CSV file for further processing.
It is possible to click on the data in the plot area or in the table and the user will be redirected to the exact selection of query for corresponding worst execution, where data can be filtered and downloaded into the CSV.

Selection filters of worst query execution

Query runtime

The visualizations show query average runtimes per some analyzed period. There are two charts visible. Left side chart displays query groups based on average runtime i.e. how many queries in system belong to each performance group during analyzed period. Right side chart displays scatter chart plot for each individual query with average runtime and number of executions. The user can filter data and also switch to the table view for more detailed information where data can be downloaded into a CSV file for further processing.

Query runtime analysis charts


User can click (drill down) in the left column chart in order to get more information about query execution. 

Query execution details table


Here it is also possible to filter or download data. User can also click (drill down) on the row in order to get more information about query execution as time when query was executed, min., max. and average query runtime and also selection string.

To this analysis it is also possible to go directly from the scatter plot in the Query runtime analysis (by drilling down on the data in the scatter plot).


Query execution details per filtering InfoObjects combinations


Here it is also possible to filter or download data or switch to table view and download data to CSV file for further processing.

Query runtime by categories

The visualizations show query average runtimes according to query processing categories per some analyzed period. Displayed categories are BI Suite, Data Manager, Olap - Cache, Olap – Olap, Olap – Authorizations and Olap – Input Help (for more info). 
Top part of analysis display average time spent in processing by each category for whole system. While bottom chart displays average processing times in categories for individual queries. 

Query runtime by categories analysis chart

The user can filter data and also switch to the table view for more detailed information where data can be downloaded into a CSV file for further processing.