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

Expert Sessions!

Important Points To Consider When You Plan for an Upgrade

31 July 2012

Written by Prakash Palani

 

When I was scanning through few documents on release/EHP upgrades, got to know many of the important tasks that should be taken care during the course of any EHP upgrade projects (any release upgrade for that matter). I just wanted to collect and list them in this blog, if you think that there is something missing in the list, do post your comments, so that I can keep the blog updated to make it comprehensive and useful for others.

 

Read Article

SQL Statement Tuning - Part 3

31 July 2012

Written by Prakash Palani

 

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 Article

Preliminary Analysis - Expensive SQL Statement

31 July 2012

Written by Prakash Palani

 

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 Article

SQL Statement Tuning - Part 2

31 July 2012

Written by Prakash Palani

 

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 Article

I/O Performance - MSS

31 July 2012

Written by Prakash Palani

 

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 Article

Latest Articles

  1. No Service for System SAP (1999-11-30 00:00:00)
  2. WebUI Not Starting (1999-11-30 00:00:00)
  3. WebUI Not Starting (1999-11-30 00:00:00)
  4. No RFC Destination for SID (2014-05-15 10:20:15)
  5. SQL 2005 Installation - number of CPUs is not a power of 2 (2014-01-03 04:59:23)

FollowUs on Twitter

SAP Web Dispatcher

SAP Web Dispatcher

Defining Backup Strategy

Defining Backup Strategy

Security Patch Strategy

Defining Security Patch Strategy

RCA Setup Guide

RCA Setup Guide for BI SBOP (BOBJ)

End-To-End SSL Setup

End-To-End SSL Setup Guide for Web Dispatcher