Using the Performance Statistics and Analysis Tool

Objective

After completing this lesson, you will be able to describe how the Performance Statistics and Analysis tool can be used to analyze performance.

Performance Statistics and Analysis Tool

The Performance Statistics and Analysis tool is a predefined story created by SAP to analyze performance across stories and users.

This tool helps to identify scenarios that have a high-performance impact in the connected backend system. For example, finding out that a broken query in the backend system is blocking processing resources for other users querying that system. You can analyze such things as how a recently established connection affects your backend system, what is the heaviest query, or which models can be improved.

The Performance Statistics and Analysis story contains the following pages:

  • Overview
  • Backend
  • Frontend
  • Network
  • Long term analysis

Access the Tool

You can launch the tool by going to SystemPerformanceStatistics and Analysis as shown here.

Menu path for the SAP Analytics Cloud Statistics and Analysis tool.

Overview

The Overview page contains performance KPIs for users, frontend, and network with top 10 users, stories (resources), and connections by queries, as well as models by total execution time.

The Statistics and Analysis tool Overview page.

Backend

On the Backend page, you can analyze KPIs related to query runtime, for example:

  • Performance impact for model and story combinations
  • Median query runtime for stories
  • Average query runtime history
The Statistics and Analysis tool backend page.

Frontend

On the Frontend page, you can analyze KPIs related to logon, for example:

  • Users with highest logon duration
  • Number of logons
  • Median logon duration
The Statistics and Analysis tool Frontend page.

Network

On the Network page, you can analyze KPIs related to network, for example:

  • History of median network time
  • Top 10 users by median network time
  • Maximum network time per session date
The Statistics and Analysis tool Network page.

Long Term Analysis

The Long Term Analysis page offers long term statistics related to frontend, log on, and backend. You can review the frontend and backend long term statistics by count or percentile using the radio buttons to the left of the chart.

The Statistics and Analysis tool Long Term Analysis page.

Log in to track your progress & complete quizzes