EWA - Expensive SQL Statements Review Methods

Overview

• Expensive SQL Statements
• Assistance with resolving Expensive SQL Statements:
• Expensive SQL Statements incomplete or missing in the EWA report

Expensive SQL Statements

Expensive SQL Statements displays detailed information about the most expensive SQL statements

For a complete explanation of the rating for SQL Server - Refer to SAP Note 2021756 - MSSQL Expensive SQL statements check. Rating strategy for EarlyWatch Alert.

For an explanation of the rating strategy for Oracle - Refer to SAP Note 551646 - Oracle SQL check rating strategy for EarlyWatch Alert.

Assistance with resolving Expensive SQL Statements:

1. Create a SAP Technical Performance Optimization (TPO) service on Solution Manager  - This is a database tuning service that will look at the current state of your database and make recommendations in regards to performance optimizations, index.
   Refer to the wiki link https://wiki.scn.sap.com/wiki/x/p4fHGg for steps how to create a TPO Self Delivered Service.
2. If you require further assistance, use the component SV-PERF. Upload the EWA report and the TPO report. 

Expensive SQL Statements incomplete or missing in the EWA report

1. Ensure the latest add-on ST-PI is on the managed system by running ST13 - RTCCTOOL.
2. Verify the latest add-on  ST-PI on Solution Manager by running ST13 - RTCCTOOL (it is very important Solution Manager is also using the latest ST-PI).
3. On Solution Manager, ensure the latest Service Content is on the system using transaction AGS_UPDATE.
4. Check SAP Note 2180792 - EWA: No Source Code in Expensive Statement section.
5. Refer to SAP Note 2475365 - EWA report is missing sections "Database server load from expensive SQL statements" and "Database and ABAP Load Optimization"
6. If the subsequent EWA is still not correct, use component SV-SMG-SER-EWA.