1. Skip to Menu
  2. Skip to Content
  3. Skip to Footer>

Expert Sessions!

SQL Statement Tuning - Part 4

Friday, 20 April 2018 01:07

 

SolutionDB/Solution Database

Another interesting tip on Expensive SQL Statements, it helps you to quickly find a solution for expensive sql statements that are originating from SAP Standard Programs/logics.

Read more...

SQL Statement Tuning - Part 3

Friday, 20 April 2018 01:07

 

In this article, we will be discussing the so called "unsuitable access path" that may get chosen during the SQL Statement Execution.

Sample SQL Statement goes like this : select * from LIPS where MANDT='001' and VGBEL='00009869'.

 

Read more...

Preliminary Analysis - Expensive SQL Statement

Friday, 20 April 2018 01:07

 

When it comes to identifying Expensive SQL Statements, my approach in  identifying the statements is to use the preliminary analysis as indicated in this article, Steps indicated in the below flowchart help you to take step-by-step approach to identify the expensive SQL statements.  If you are able to identify the expensive SQL statements, then it is worthwhile to proceed further with Detailed Analysis towards database, if not, then the focus should be turned on different areas such as Workprocess, Hardware Bottleneck, etc.,.

 

 

Read more...

SQL Statement Tuning - Part 2

Friday, 20 April 2018 01:07

 

Have you ever looked at the column identical in ST05 analysis results, it is one of the interesting information that you see in ST05. It will help you to get the list of identical selects that tells you how often each identical select was executed during the SQL Trace.

 

Read more...

I/O Performance - MSS

Friday, 20 April 2018 01:07

 

An easy way to check I/O performance in SAP system based on Windows/MSS

In order to achieve optimal I/O performance, it is imperative to evenly distribute the read accesses and write accesses on the hard disks of your production system (any system for that matter). An high level view on the I/O performance can be checked in transaction ST06, in addition to ST06, there are other options using which you can check the I/O performance. This blog is about how you can check the I/O performance of an SAP system based on Windows/MSS database.

 

Read more...

Performance Tuning