topic Re: SAP Performance tuning in Application Development and Automation Discussions

SAP Performance tuning

Former Member — Thu, 29 Jun 2006 10:57:55 GMT

What measures shall we take if it is needed to performance tune the SAP Server. It is getting too slow. It will be helpful if someone can send me some link about SAP Performance tuning, not ABAP performance tuning.

Regards,

Subhasish

Re: SAP Performance tuning

Former Member — Thu, 29 Jun 2006 11:00:39 GMT

Hello Ganguly,

U can try some of these ways:

1. Clear all lock entries from the tcode SM12

2. Clear the obsolete logs from the Tc SLG2 with the Generate List radio button selected.

May be these two things fasten ur server

Regards,

Vasanth

Re: SAP Performance tuning

Former Member — Thu, 29 Jun 2006 11:12:13 GMT

Subhasish,

Indexes do get fragmented and BASIS normally should have this planned in their DB13 – DBA Planning Calendar as this can affect performance,

You can try these.

STAT – Display Statistical Records

DB02 – Database Performance : Tables and Indexes.

DB05 – Analysis of Table w.r.t. Indexed Fields

ST04 – DB Performance --> ‘Detailed Analysis’ button

--> ‘SQL Reads’ button

Regards

David

Re: SAP Performance tuning

Former Member — Thu, 08 Jan 2009 06:44:58 GMT

The SAP Servers can be slow because of many reasons:

1. The Table Consistency: The tables should be consistent. A consistency check should be done regulalrly.Better would be using DB13 so that it can be scheduled in appropriate days.

2. One major reason that I have found in recent times is the amount of authorizations that might be available to the users of the sytem. If all the users have a high volume of authorization objects in their user master buffer, then the response time becomes sluggish.This is true for most of the dev boxes that allow almost any amount of authorization for users and have a low RAM size.

3. Also you might be intrested to check your network consistency. If you are accessing your servers from home with a wireless connection of 16kbps, you might want to configure your logon pad for such a crappy connection.

Most of the BASIS performance tuning tasks such as ST04, STAT, ST02 and DB12 should be carried out too just to investigate furthur.

Hope these were a few helpful tips.

Peace be with everybody

-Saurav

Re: SAP Performance tuning

Former Member — Thu, 08 Jan 2009 06:51:47 GMT

Hi,

Please go through the below links.

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/abap/abap%2bperformance%2band%2btuning

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/abap/performance%2btuning

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/abap/abap4%2btuning%2bchecklist

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/abap/advanced%2bperformance%2boptimization%2btechniques

Hope links are usefull.

Regards,

Phani.