SAP Knowledge Base Article - Public

3656539 - SAC Performance And Statistics - "Performance Impact" metric

Symptom

With regard to SAC Performance And Statistics
Performance Impact / Backend Query CPU Time and Runtime Statistics in Relation to Query Count

There is a metric called, "Performance Impact" the definition is desired.

Environment

SAC Performance And Statistics

Resolution

Performance Impact is calculated by average response time squared multiplied by number of queries. 
Performance Impact = (Avg response time)^2 * Number of Queries

This helps to identify problematic scenarios and unhealthy content. It was introduced after being proven useful in many customer cases to identify performance issues. This metric gives consideration to both complexity and frequency. The number of queries alone has limited value because a high count of queries that are fast are not a problem. The same for high average runtimes. If a query takes a long time but runs only once a week that will not likely be focus for general performance issues.

Keywords

KBA , LOD-ANA-XUS , User assistance, performance statistics , LOD-ANA-AD , Analytics Designer , Problem

Product

SAP Analytics Cloud 1.0