Show TOC

Procedure documentationOptimizing the Performance of SQL Check Steps Locate this document in the navigation structure

 

To optimize the performance of SQL check steps, you can check how fast the SQL check steps for an analysis were executed in specific systems (logical components) and in various evaluation periods. This allows you to determine which SQL check steps generated the most workload. You can try to improve those SQL check steps that place a particularly heavy strain on the system or replace them with other methods suitable for analyzing the relevant analysis structure nodes.

Prerequisites

You have clicked on the name of an analysis in the Analyses view, to open the results overview.

Procedure

  1. Choose the Report tab.

  2. Choose the Display SQL Check Step Execution Time Report link.

    The execution times are displayed (in seconds).

Note Note

You can configure the report under Settings, for example, to display the execution times of SQL check steps for each client or system.

End of the note.