Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

SAP Performance tuning

Go to solution
Former Member

‎2006 Jun 29 11:57 AM

0 Likes
735

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

1 ACCEPTED SOLUTION
Read only

Go to solution
Former Member

‎2006 Jun 29 12:12 PM

0 Likes
679

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

4 REPLIES 4
Read only

Go to solution
Former Member

‎2006 Jun 29 12:00 PM

0 Likes
679

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

Read only

Go to solution
Former Member

‎2006 Jun 29 12:12 PM

0 Likes
680

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

Read only

Go to solution
Former Member

‎2009 Jan 08 6:44 AM

0 Likes
679

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