Bottleneck Analysis (SAP DB) (SAP Library

Bottleneck Analysis (SAP DB)

For the results of the current bottleneck analysis on the database server, choose Bottleneck analysis in the Detail Analysis Menu.

To restart the bottleneck analysis on the database server, choose Bottleneck analysis ® Restart x_wizard.

The bottleneck analysis tool x_wizard executes the bottleneck analysis. The tool looks for bottlenecks in the database system at regular 15-minute intervals. These bottlenecks could be low cache hit rates or negative values for table searches. The results of this analysis are displayed in text form to provide the database administrator with a quick overview of possible causes of performance problems.

Calling

If you call the bottleneck analysis using CCMS (Bottleneck analysis), all required settings for a routine bottleneck analysis of the database system are set.

If necessary, you can also start the bottleneck analysis on the operating system level. If this is required, contact local support.

Results

If bottlenecks are found, they are assigned an importance as follows:

I: Information
W1: Low-grade bottleneck warning
W2: Medium-grade bottleneck warning
W3: Severe bottleneck warning
This classification of warnings is used for applications that have been running for a while (steady system). You can usually ignore warnings that appear just after starting the database system.

All results may not necessarily be caused by true bottlenecks (table searches may make sense in certain cases, long SQL statement runtimes may be necessary for large amounts of data, and so on). In particular for poor search strategies (rows read / rows qualified), you need to analyze the situation further.

Activities

For information about how to fix the bottleneck, see Bottleneck Analysis Messages.