Skip to Content
avatar image
Former Member

SAP system performance problems

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Jan 11, 2015 at 06:32 PM

    Hi Samid

    1. On your ECC system when system performance getting slow or degraded, check the following transaction codes to know the system status

    SM66 – To check over all global workprocess status, any table keeps on reading or getting struck?

    SM21 – Check the any error log

    ST02 – Memory / Buffer usage?

    ST22 - Any time out or DBIF ... Dumps?


    2. Most of the time Z-reports are running long time. Due to this normal transaction users are getting affected. For this you can enable the transaction code ST12 trace check the overall DB & ABAP program usage.


    3. On your Cluster environment one node can have DB & Application instance and another node can handle the end user transactions. Since the windows 2003 server end of support on this year try to upgrade the existing system to either windows 2008 or 2012 with Failover cluster.


    4. On your MS SQL DB have you define the 30% of memory for DB? And also you can refer the SCN link how to tune the MS SQL DB

    Tune your SQL Server SAP Database


    BR

    SS

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 12, 2015 at 09:32 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 21, 2015 at 12:16 PM

    Hi Samid,

    From the screen shot of ST02, its clear that the export/import buffer overflow has occured and high number of swaps has occured. High number of swaps will always a major concern in performance point of view.

    Please refer the below notes to improve the export/import buffer

    373986 - Overflow of the export/import buffer

    702728 - Profile parameters for export/import buffer instances

    649613 - Export/import buffer SWAPS

    Regards,

    Nikhil

    Add comment
    10|10000 characters needed characters exceeded

    • Thank you Nikhill, I completely miss the Export/Import Buffer hit ratio. It is fine if this buffer has Hit Ratio % above 80%, but in this case the Hit Ratio is below 80% and the buffer size should be raised.

      Anyway, in this case I think that the system performance issue is not related with a wrong seize on the buffers.

      Best regards.

  • avatar image
    Former Member
    Jan 11, 2015 at 05:17 PM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 12, 2015 at 08:42 AM

    Hi Samid,

    There are lots of docos and wikis and stand practise that you will check, however, I would like to know what are the changes you have done recently on your DB and kernel ?

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 15, 2015 at 02:11 PM

    I'm wondering if extended memory is set sufficiently - what is the value for EM/TOTAL_SIZE_MB?

    In ST02, what are the figures shown for extended memory?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Ross Armstrong,

      I don´t have any parameter with that name EM/TOTAL_SIZE_MB! This is a SAP ERP 4.7 version... I don´t know if it's related with this version or not, but I can't find that parameter.

      In ST02 I see the following values:

      Any tip?

      Thank you,

      samid raif

      Untitled.jpg (137.1 kB)
  • Jan 15, 2015 at 05:25 PM

    Hello SS,

    A performance problem on the system can be caused for different reasons:

    - Not enough resources during the process. For example, the extended memory of the system is exhausted an the process finish with an error. Or the CPU of the server is not enough and it will cause a bottleneck.

    - Network problems or communication problems, between the different elements of the SAP systems or between users and system.

    - Bad use of transaction by end users or user appreciation of the system performance.

    - Etc.

    I will check the following things to find where the performance issue is:

    - Check the available resources of the system: Is there enough memory (roll, extended, heap) in the system (ST02)? Is the CPU at 100% or near 100% (ST06)? Is there enough physical memory all the time? What is the hit ratio % of each buffer on transaction ST02?

    - Is there any dump on transaction ST22 that are related with insufficient memory on the system? Is there any message related with performance issues on transaction SM21, like for example connections timeout, message related with not enough resources, etc?

    - Check the response times  for instance and logon groups on transaction SMLG. Which is the value?

    - Check the hourly response times on transaction ST03. Compare them with previos values from other days, weeks or months, are they higher?

    - Is the performance on the database good? Check transaction DB02. How is the CPU use on the database server?

    - All the users complains about system performance or just some users? All the transactions or actions done in the system are affected by the performance problem or just some transactions?

    Just to know, SAP doesn't make any real difference between Physical and SWAP memory. What I mean is that you define a pool of Virtual Memory between Physical and SWAP memory, then assign it to the SAP system with the system parameters and the SAP system uses that pool as it wants, so it is a normal situation if you find that SAP system is not using physical memory even if there is memory available. Of course there can be a problem related with wrong memory settings (for example, the amount of swap space you defined considering the physical memory of your server) but SAP systems doesn't always use physical memory.

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Samid,

      The values showed on your screenshot are good:

      - The Hit Ratio % of each buffer are between the recommended levels by SAP.

      - There is no swaps on the buffers, just the Export/Import buffer has swaps and it is acceptable.

      - There is enough roll, extended, paging and heap memory and it is not completed anytime.

      Just one thing: You said on your last post that your SAP server has about 24GB RAM memory. Your extended memory is 13GB size and it should be higher because the virtual memory on your server should be 24GB RAM + Swap space defined (3xRAM Memory at least). Anyway, this is just a recommendation and it is not the performance issue.

      Check the rest of topics I wrote on my answer. Also, how many work process has your server? Is there always dialog work process available all the time?

      Best regards.

  • Jan 21, 2015 at 04:07 PM

    Hi ,

    From the screenshot dont think that you have any sort of memory issues  due to the parameter setting

    of the memory .

    Please provide a screenshot of the TXN ST06 .

    You have mentioned that users are facing performance issues when executing certain transations . Have you done a trace for these transactions /users using ST12 or ST05

    Please Dig in more using transaction ST03N / STAD  . You will get more details

    Response Times: Rules of Thumb - CCMS Monitoring - SAP Library

    All performance problems may not be memory . It could be CPU , network etc .

    Thanks ,

    Manu

    Add comment
    10|10000 characters needed characters exceeded