Performance Analysis in CCMS: liveCache 
The DBA Cockpit and liveCache Assistant supply a comprehensive range of analyses tools for your liveCache. You can get the most important 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 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
A 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 liveCache was started, see the line External DBPROC calls in the Monitor display in the liveCache Assistant. To set and use your liveCache optimally, you can automate DBA actions that are necessary.
Procedure
Carrying out a liveCache performance analysis means that you can check a wide range of settings, access times and hit rates of your database system. If necessary, the applications can then be included 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 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 liveCache performance analysis can basically be carried out in the steps described for OLTP databases. Special features for the liveCache are indicated if necessary. Proceed as described in the following documentation for a detailed performance analysis: Database Administration in CCMS: MaxDB, Executing Performance Analysis in CCMS
More Information
Monitoring the Main Memory Areas
SAP Notes: 819641 (FAQ: MaxDB Performance), 819324 (FAQ: MaxDB SQL Optimization)
Concepts of the Database System, Performance, Analyzing Performance Bottlenecks, Troubleshooting
Database Analyzer documentation
XCONS documentation