Monitoring Query Runtime
Statistics
Use
You can monitor runtime trends and deviations from runtimes of successfully executed BI applications. These include BI applications, BI application objects, and InfoProviders. Select the relevant BI applications from:
Available BI applications (BI applications, BI application objects, and InfoProviders)
BI Applications |
BI Application Objects |
Info Providers |
· Web templates · Workbooks |
· Queries · Query views · Planning functions · Web items |
· InfoObjects · InfoCubes · DataStore objects · InfoSets · MultiProviders · Aggregation levels |
You use the time trends to analyze and optimize system performance. They also allow you to identify BI objects that are adversely affecting system performance.
Procedure
1. In the Detailed Navigation pane, under Query Runtime Statistics, select the <BI application>.
<BI application> can be BI application statistics, BI application object statistics, or InfoProvider statistics.
2. On the <BI application> Statistics screen, in the BI Systems Selection area, select your BW System.
3. On the <BI application> Statistics screen, in the BI Application Selection area, select your BI application from the list.
You must choose at least one BI application to display the performance details.
4. Choose Submit.
5. Check the following iViews for BI applications:
Short-Term Trends in Total Runtimes of <BI Applications>
You can view changes to the runtimes of BI applications successfully executed in the last 24 hours. This iView is graphical and provides the following information:
Information |
Description |
Total Time |
Total time taken (in seconds) to successfully execute individual processes (for example, data manager or OLAP processing) of the BI application. The value is rounded to the nearest second. |
Hour |
Hour during which the BI application was successfully executed.
If the BI application object was successfully executed during the third hour of 24 hours, the graph displays 3. |
<BI application> |
Technical names of up to five BI applications with the longest runtimes. |
Long-Term Trends in Total Runtimes of <BI Applications>
You can view changes to the runtimes of BI applications successfully executed in the last 30 days. This iView is graphical and provides the following information:
Information |
Description |
Total Time |
Total time taken (in seconds) to successfully execute individual processes (for example, data manager or OLAP processing) of the BI application. The value is rounded to the nearest second. |
Calendar Day |
Date on which the BI application was successfully executed. The date format is day.month.year (DD.MM.YEAR). |
<BI application > |
Technical names of up to five BI applications with the longest runtimes. |
Runtimes of <BI Applications>
You can view the durations for successfully executed BI applications. In this view, you can also see the runtimes for individual processes, such as data manager or OLAP processing. This iView is tabular and provides the following information:
Information |
Description |
Tp. (Type) |
Icon for BI
application type. For example, |
<BI application> |
Technical name of the <BI application>. |
Total Time |
Total of all runtimes (in seconds) for the individual processes involved in successfully executing the BI application. |
Front-End Time |
Runtime (in seconds) for successful execution of the front-end processing for the BI application.
This only applies to BI applications. |
OLAP Time |
Runtime (in seconds) for successful execution of the OLAP processing for the BI application. |
Data Manager Time |
Runtime (in seconds) for successful execution of the data manager processing for the BI object. |
Planning Time |
Runtime (in seconds) for planning activities involved in successful execution of BI applications.
This field is only relevant for to BI applications. |
Other Times |
Runtime (in seconds) for activities that are not assigned to Front-End Time, OLAP time, Data Manger Time, Planning Time.
This field is only relevant for to BI applications. |
Average <BI application> Count per hour during last 24 hours |
Average number of successful executions per hour of BI applications for the last 24 hours. |
Average <BI application> Count per day during last 30 days |
Average number of successful executions per day of BI applications for the last 30 days. |
Average <BI application> Count per hour during last 30 days |
Average number of successful executions per hour of BI applications for the last 30 days. |
Deviations in Runtimes of <BI Applications>
You can view the deviation between the short-term runtime (last hour) and long-term runtime (last 24 hours) of a successfully executed BI object. In this iView, you can also compare the short-term and long-term runtimes. This iView is tabular and provides the following information:
Information |
Description |
Tp. (Type) |
Icon for BI object
type. For example, |
BI Application |
Technical name of the BI application. |
Dev. in % (Deviation) |
Deviation (in percentage) between the short-term runtime (last hour) and long-term runtime (last 24 hours) of a successfully executed BI object. |
Short-Term Total Time |
Total time taken (in seconds) to successfully execute the BI object during the last 24 hours. The value is rounded to the nearest second. |
Long-Term Total Time |
Total time taken (in seconds) to successfully execute the BI object during the last 30 days. The value is rounded to the nearest second. |
is displayed for a
query.Result
You can identify the BI applications that are adversely affecting system performance. You use the available report-report interfaces (RRIs) to further analyze these BI applications to ascertain why they are affecting system performance.