Basis and others: January 2020

EWA - Expensive SQL Statements Review Methods

Overview

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:

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.
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

Ensure the latest add-on ST-PI is on the managed system by running ST13 - RTCCTOOL.
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).
On Solution Manager, ensure the latest Service Content is on the system using transaction AGS_UPDATE.
Check SAP Note 2180792 - EWA: No Source Code in Expensive Statement section.
Refer to SAP Note 2475365 - EWA report is missing sections "Database server load from expensive SQL statements" and "Database and ABAP Load Optimization"
If the subsequent EWA is still not correct, use component SV-SMG-SER-EWA.

2665195 - How to check your DMIS support package? - SLT

Symptom

What is my SLT package?
What is my S/4 HANA level?
How to check your S/4 Core level?

Environment

SAP Landscape Transformation replication server

Resolution

Select the 'System' button at the top of your SAP GUI screen
Select 'Status' from the drop down
Select the 'Details' button under the 'SAP System data' section
Under the Component colum you will see either DMIS or S/4 Core

Configuring Web Services in SOA Manager

Concept

You can use SOA Manager for the complete configuration of service providers and consumer proxies for a local system. The following task areas are described:

Technical Configuration

Initial setup of SOA Manager
Semantic Addressing Using Identifiable Business Contexts (IBCs)

Addressing is handled on the basis business application entities that are represented as Identifiable Business Contexts (IBCs).
Configuring Service Providers and Consumers

Configuration that is specific to each server or business scenario.
Publishing Services

Setting up the connection to the Services Registry, configuring publication rules, publishing service definitions.
Accessing and Testing a Service

Check that a service is functioning correctly and find the URL of the configured service.
Logs and Traces

Manage and configure logs and traces for Web service provider and consumer calls.
Monitoring

Check for errors in the message exchange between a service provider and a service consumer.

Prerequisites

You have Administrator authorization.

More information: Checking Roles
In transaction SICF, you have activated the following nodes:
- /sap/bc/srt (including sub nodes)
- /sap/bc/webdynpro/sap/appl_soap_management
You may have to activate the general Web Dynpro ICF services to ensure that the ABAP Web Dynpro runtime environment works. For more information, see Active Services in SICF.
The service and proxy definitions that you want to configure are available as development objects in the back-end system.

More information: Migrating Web Service Configurations
If you want to work with SOA Manager in a system landscape, you need to configure communication between ABAP systems.

More information: Setting Up the SOA Manager

Procedure

To start SOA Manager:

Use the transaction code SOAMANAGER.

Alternatively; you can start SOA Manager in an Internet browser using the following link:

http://<host>:<port>/sap/bc/webdynpro/sap/appl_soap_management?sap-language=<logon language>

The main screen is displayed, with tabs for the function groups. The main function groups are:

Service Administration	Functionality to set up configuration to support business processes with Web services. This functionality is intended for business administrators who manage business processes across systems in a system landscape.
Technical Administration	This functionality is intended for technical system administrators who set up connections between systems and who manage the security settings in a system landscape.