Show TOC

Function documentationPerformance Locate this document in the navigation structure

 

The Performance section groups together data that is relevant for system performance.

Statistics Server

Provides an overview of the tables in schema _SYS_STATISTICS. These tables contain data that is useful for analyzing system performance.

To display the content of a table, select the table and choose Display Table Content.

Threads

Displays an overview of currently active threads.

To display more information about a thread, select its row and choose Details from the context menu.

To display the full statement, select a thread and choose Display Statement String. The full statement is displayed with its structure. To display the access strategy and the execution plan, choose EXPLAIN.

When you choose EXPLAIN, the statement is analyzed. The statement is not executed; its execution is only simulated and the resulting information is then displayed. The time that the statement would need to run is estimated.

To display graphical elements for accesses, choose   EXPLAIN (Graphical)   Explain Query Plan  . Expand the boxes to see more information. The graphical elements show the estimated times, the rows accessed, and the names of the algorithms that execute the SELECT.

Expensive Statements

Expensive statements are individual SQL queries whose execution time was above a configured threshold. Expensive statements may reduce the performance of the database.

Here, you can search for and analyze expensive statements on a specific host or for a specific database user, explain, explain (graphically), and trace the execution of SQL statements.

To analyze a statement, select its row, then choose EXPLAIN or EXPLAIN (graphically).

The Execution Trace is similar to the Explain function. With Explain, the statement is not executed; with Execution Trace, the statement is executed and analyzed at the same time. The trace can be downloaded.

Note Note

By default, the expensive statements trace is deactivated. To activate the expensive statements trace, choose Configure. Alternatively, you can choose   Current Status   Trace Configuration  . The default threshold value is 1000000 microseconds (1 second).

End of the note.
SQL Plan Cache

The SQL plan cache is useful for observing overall SQL performance as it provides statistics on compiled queries. In this section, you can gain insights into frequently executed queries and slow queries with a view to finding potential candidates for optimization.

To analyze a statement, select its row, then choose EXPLAIN or EXPLAIN (graphically).

To display a full SQL statement, select a row and choose Display Statement String.

To display this information in SAP HANA studio:

  1. Open Administration.

  2. Go to the System Information tab.

  3. Open SQL Plan Cache.

Performance Warehouse

Note Note

Information is available in this section only in Solution Manager systems.

End of the note.

You can analyze performance data of your database system using the Performance Warehouse. To access the Performance Warehouse, start DBA Cockpit and choose   Performance   Performance Warehouse  .

The following content areas are available in the Performance Warehouse:

  • Reporting

    By default, the Reporting content area is displayed.

  • Configuration

    If you are using the SAP GUI-based user interface, the application starts in a separate Web browser.

Prerequisites

An SAP Solution Manager system with Solution Manager Diagnostics (SMD) enabled is required.

Features

In the Performance Warehouse, all relevant performance indicators that are collected by DBA Cockpit are stored in an SAP Business Intelligence (BI) system. This SAP BI system is used by the Solution Manager Diagnostics (SMD) back end of an SAP Solution Manager system. SMD already uses this SAP BI to store workload data of SAP applications. To configure the extraction of data into the SMD BI, you use the SMD Setup Wizard.

Based on this architecture, DBA Cockpit uses SAP BI technology to provide reports for performance analysis, which you can customize according to your needs. All collected data has a time dimension, so you can analyze the database performance for any point in time or over a specified time frame.

Almost all reports are displayed as a chart to visualize the key performance indicators (KPIs). In addition, there is also a detailed table view. To navigate within these reports, you can use the SAP BI drilldown feature. Violations to performance thresholds are highlighted based on predefined SAP BI exceptions to make you immediately aware of performance issues.

The Performance Warehouse is shipped with predefined content that you can use to create your own reports according to your needs.

Function

Description

Reporting

You use the data provided on the Reporting screen to analyze database performance problems in the present or the past. To access the Reporting screen of the Performance Warehouse, start DBA Cockpit and choose   Performance   Performance Warehouse   Reporting  .

The reports are categorized and for each category there is one tab. On each tab, you can choose a button to display a specific view on the database performance, for example, I/O, Prefetcher, Sort Heap.

Note Note

If you are using the SAP GUI-based user interface, a separate Web browser opens for this application.

End of the note.

Specifying the Time Frame

To display detailed reports, you first have to specify the time frame for which you want to analyze data by defining the following:

Granularity

You can choose between Hour, Day or Month. Depending on your selection, the values for your time frame might change.

Time Frame

If you choose Custom Selection from the drop-down list, you can manually enter the starting and ending time for your analysis. To activate your custom selection, choose Apply Filter. For any other selection from the drop-down list, the reports are automatically refreshed.

Displaying a Report

To display a report, choose the appropriate button on the respective tab.

The reports consist of two sections:

  • In the upper section, a chart is displayed to visualize the key performance indicators. The chart provides a subset of the key columns from the detail table view.

    The chart display is optional and not available for all available views.

  • In the lower section, a detailed table view is available.

  • You can drill down your reports by either using the context menu of a column header in the Detail:<Category – View> screen area or by specifying the respective value using the buttons in the Detail: Navigation screen area. Here, you can also add and remove columns or key figures, or you can set filters on columns.

    In addition, there are predefined exceptions (for example, Chart: Exceptions or Details: Exceptions) for almost all reports on key performance indicators. The used thresholds are based on Early Watch Alerts and each violation to these thresholds is displayed in red.

    Note Note

    To reset a report to its initial state, choose Reset Report in the central system area.

    End of the note.

Note Note

The availability of the tabs and of the buttons on each tab can vary depending on the selected system. Some reports are only available if special database features are enabled.

End of the note.

You configure all configuration parameters that are related to the performance warehouse on the Configuration screen. For example, you can configure the framework, the templates used for the reports and the report categories.

DBA Cockpit uses BI Business Explorer (BEx) Web templates to analyze the performance data that is stored in the Solution Manager Diagnostics (SMD) BI. You can create your own BI BEx Web templates based on this data and integrate new BI BEx Web templates into the performance warehouse.

To access the Configuration screen of the performance warehouse, start DBA Cockpit and choose   Performance   Performance Warehouse   Configuration  .

Note Note

If you are using the SAP GUI-based user interface, a separate Web browser opens for this application.

End of the note.

On the Performance Warehouse: Configuration screen, the following tabs are available:

  • Configuration

    Here, you can view or modify the configuration parameters of the performance warehouse for the monitored system. To modify some of these parameters, use the Edit, Save and Cancel buttons.

    Depending on your database platform, the displayed selection of values can vary. The following parameters are displayed for all database platforms:

    • BI Server

      BI server where the database performance data is located

    • Managing DBA CockpitThis DBA Cockpit is allowed to change any data collectors or performance warehouse configuration for this database. By default, DBA Cockpit of the Solution Manager system is used for this task.

    • Reporting Time Zone

      The performance data timestamps are converted to one global time zone for all reports in SMD BI.

    Note Note

    The Default checkbox is selected if the default value for your complete landscape is the same as the one specified for your system.

    End of the note.

  • Web Reports

    Here, you can configure the display on the Reporting screen. That is, you can view and modify the integrated BI BEx Web templates in the tree table. To modify some of these parameters, use the Edit, Add and Delete buttons in the toolbar.

    The main report categories appear and for each report category, you can view or modify the views by expanding the appropriate report category. These views appear as buttons on the respective category tab on the Reporting screen. To change the sequence within a category, use the Up or Down buttons.

    To display details about a view, simply select it in the table. The following parameters are displayed in the Details for Web Reports area below the table view:

    Parameter

    Description

    Report

    Specifies the name of the report

    This text appears on the view button on a category tab.

    Description

    Detailed description for the report

    This text appears as a tooltip for the button of the key indicator on a category tab.

    Category

    Specifies the report category.

    Each category is represented on a separate tab.

    Web Report (Default)

    Technical name of the BI BEx Web templates

    Web Report (Day)

    Technical name of the BI BEx Web templates for granularity Day

    Web Report (Month)

    Technical name of the BI BEx Web templates for granularity Month

    Data Providers (Time)

    Specifies the data provider of the BI BEx Web templates with a time dimension. The drilldown of the time dimension is changed according to the selected granularity.

    Active

    If selected, the report is available for performance analysis.

    Default

    If selected, the report is executed as soon as the tab is selected.

    Database

    Name of the database platform

    Release (min)

    Minimum database release for this report

    Release (max)

    Maximum database release for this report

    Note Note

    Depending on your database platform, there might be more checkboxes available for database-specific features. If you select these checkboxes, the report is only displayed if the specific database features have been set up in the monitored database system.

    End of the note.

  • Report Categories

    Here, you can view and modify the categories for BI BEx Web templates of the reports that are displayed the Reporting screen. To modify some of these parameters, use the Edit, Add and Delete buttons in the toolbar. To change the sequence of the categories on the Reporting screen, use the Up or Down buttons.

    The following parameters are displayed:

    Parameter

    Description

    Category

    Name of the category

    Description

    Detailed description for the category