SAP system performance problems

[Former Member]

Hello,

I´m trying to understand something about how and what can be done to improve our SAP system performance.

First of all this is a SAP ERP system that is installed in a windows server 2003 on a MS SQL Server database (in a cluster - cluster administration). We noticed that the performance of this SAP system is not the better and some users told us that some actions during the transactions are slow. The two servers (two cluster nodes) have a lot of RAM memory and also page file so I believe this problems are not related with this particulary things.

Can you told/teach me how can I check and measure if the system are with some problems!? Which transactions I must check to make this analysis and how can I correct/improve this situation?

Can you tell me please some tips regarding this type of problems?

Thank you,

samid raif

[Former Member]

Hi Samid,

Please check the below URL for the performance tuning:

ABAP
Performance and Tuning - ABAP Development - SCN Wiki

   SAP R/3 Performance Monitoring and
Tuning

http://scn.sap.com/docs/DOC-47062

Regards,

Rishi

[Former Member]

Hello to all,

First of all thank you for the information and the knowlegde that you share!

I will try to explain you what is the main problema here, that is very strange thing (or not... I don´t know exactly ).

As I told you this is a cluster platform, the node 1 has the MS SQL Server database and the node 2 has the SAP instance. Both servers have 24Gb of RAM each and the problem is the node 2 (where the SAP instance is) only use 3-5 Gb of RAM memory and it begins to catch the page file memory! I don´t understand why... because the PHYS_MEMSIZE has the value 20000 (20Gb) and I believe the server must use more RAM memory instead using the page file with a lot of free RAM memory!

Any idea why this is happen?

Thank you,

samid raif

[S_Sriram]

Hi Samid

1. On both nodes increase the virtual memory=physical ram(24gb) x 3 times = 72 GB

2. On both nodes most of the parameters should be same(Like profile parameters No of workprocess,Memory buffers values, physical node configurations) because at any point of time one of the node will act as a CI,

3. After rebooted the system initially it takes 3 to 5 gb, based on over all usage it will increase  using the physical & virtual memory.

BR

SS

[Former Member]

Hi SS,

Thank you for your answer Sriram.

1. Regarding that... we already increase the virtual memory to 72Gb

2. The instance profile has the following parameters:

I also checked the ST04 transaction:

Any tips?

Thank you,

samid raif

[S_Sriram]

Hi Samid

1. You can keep referenece of the SAP Note to increase or decrease  the memory & buffer values and also keep the memory & buffer values on both nodes same.

88416 - Zero administration memory management for the ABAP server

2. You can check memory & buffer usage on transaction action ST02. check the over all swaps

BR

SS