Show TOC

Analyzing the Performance of SQL StatementsLocate this document in the navigation structure

Context

If the performance of your database is below your expectations, there may be several reasons for this. For example, your hardware might not be powerful enough, or other applications may be taking up too many system resources.

SQL performance analysis in Database Studio helps you investigate which SQL statements from the application are particularly cost-intensive for the database, and why this might be the case.

Procedure

  1. Configuring the SQL Performance Analysis
  2. Displaying Bottleneck Candidates
  3. Analyzing Bottleneck Candidates

Next Steps

SAP Note 819641 Information published on SAP site(FAQ: MaxDB Performance)

Database Administration, Analyzing the Database Performance