Procedure documentationPerformance Analysis in CCMS: SAP liveCache Locate this document in the navigation structure

 

The DBA Cockpit and liveCache Assistant supply a comprehensive range of analysis tools for systems with SAP liveCache technology. You can get the most important SAP liveCache status information, including: name of the database connection, liveCache name, liveCache computer, liveCache version and liveCache status.

For an initial overview of important key figures needed to assess SAP liveCache performance, check the data cache load and the usage of the OMS heap. Hit rates, such as the hit rates of the data cache and the converter, can also give you important information. There are additional comprehensive tools for liveCache monitoring available.

Prerequisites

An SAP liveCache analysis can give you meaningful information only if more than 50000 DB procedures have already been executed. For an overview of how many DB procedures have been executed since the last time SAP liveCache was started, see the line External DBPROC calls in the Monitor Statistics display.

To set up and use your SAP liveCache optimally, you can automate DBA actions that are necessary.

Procedure

Carrying out an SAP liveCache performance analysis means that you can check a wide range of settings, access times and hit rates of your database system, and then, if necessary, can include the applications in further analyses. As each performance analysis runs individually, the following suggestions are merely a collection of ideas. To analyze performance bottlenecks, you can use a number of CCMS transactions, in particular DBA Cockpit, liveCache Assistant, and liveCache Alert Monitor. To determine, for example the SAP liveCache status, you can use the Properties user menu (DBA Cockpit/liveCache Assistant) or the State and Installation displays in the liveCache Alert Monitor. Experts can use further database tools, such as the Database Manager, the Database Analyzer and XCONS.

The SAP liveCache performance analysis can basically be carried out in the steps described for OLTP databases. Special features for SAP liveCache are indicated if necessary. Proceed as described in the following documentation for a detailed performance analysis: Database Administration in CCMS: SAP MaxDB, Executing Performance Analysis in CCMS

More Information

Monitoring the Main Memory Areas

Monitoring OMS Versions

Monitoring the Log Area

Monitoring the Data Area

Problem Analysis

SQL Optimizer in CCMS

SAP Notes: 819641 (FAQ: MaxDB Performance), 819324 (FAQ: MaxDB SQL Optimization)

Database Administration, Analyzing Database Performance, Troubleshooting, SQL Optimizer Statistics, Database Parameters

Concepts of the Database System, Tasks

Documentation for Database Analyzer, XCONS

Note Note

The documentation for the SAP MaxDB database system also generally applies to SAP liveCache technology. If there are functional differences, these are explained.

End of the note.