Skip to Content
avatar image
Former Member

My SAP system is extremely slow

Here is system info:

ECC60

windows 2003 R2 64 bit

SQL Server 2005 64 bit

Dialog workload info:

Number of Dialog Steps :67

Average Response Time/Dialog Setp(ms): 3499.1

Average Processing Time/Dialog Step (ms): 775.3

Average CPU Time(ms): 104.9

Average Database Time/Dialog Step (ms): 1398.5

Average Wait Time/Dialog Step (ms): 3.7

Average Roll In Time (ms): 66.2

Average Roll Wait Time (ms): 79.7

Average Load and Generation Time (ms): 256713.8

Average Lock Time/Dialog Step (ms): 18.2

Average Frontend Network Time (ms): 71.4

Average GUI Time/Dialog Step (ms): 90.7

Number of Roundtrips: 96

Requested data (KB): 19243

=========================================

Can someone please help me on this issue???

Thanks in Advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 20, 2008 at 10:49 AM

    Hello Leo,

    I would suggest you to schedule Earlywatch service from SAP, so that your concerns can be verified. To do this create OSS message in component 'SV-BO-REQ'.

    Yours Sincerely.

    Dileep

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 17, 2008 at 06:55 PM

    Hi Leo,

    There are number of possibilities for a slow performance but in this narrow platform lets

    start with some basic problem and will sort out where the actual issue lies.

    1. Here i could say some lost time is there in processing time

    Proc time = Response time - Wait time - Load time - Generating time -

    -Roll (in+wait) time - DB time - Enqueue time

    Just check it!!

    2. As per the threshold, processing time should not be more than 2*CPU. However,

    based on our data from ST03N, the processing time is more than 2X CPU

    time which might be due to hardware bottleneck or communication problem

    etc...

    So monitor theCPU utilisation like ideal CPU % and all.

    3. See the swaps happening in st02.

    As from the statistics i could see the high load and generation time.

    And high load and generation times normally indicates the program buffer is

    too small. If possible consider of increasing the value.

    4. See the transaction profiles and the tables acessed through ST04. As here the DB time

    is high we need to see tuning of expensive sql statements and more things....

    5. Does your system runs in Cluster scenario and the memory management moreover

    the ZAMM.

    Would like to expect some more input from you so that we can discuss on this regard.

    Hope this will help.

    Thank you,

    Tilak

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Average Load and Generation Time (ms): 256713.8

      is this new installation? or have you performed any support pack installation? i can see load and generation taking long time then expected.

      please schedule SGEN if you have done this before.

      Cheers,

      -Sunil

  • avatar image
    Former Member
    Oct 19, 2008 at 09:03 AM

    Hi,

    We can see the Load and generation time to be too high. The user request is each time fetching the data from the database which is taking a long time.

    The load in Generation time is a part of response time and as per the data provided load in generation time is greater than avg dia response time.

    Suggest you to schedule SGEN.

    Hope it helps.

    Regards,

    Rupali

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 20, 2008 at 07:05 AM

    Hello,

    I can see the total number of dialog steps are just 67. So I assume that you have probably taken statistics for a very shorter duration or it is an SAP system you just installed. If later is correct, then performance statistics that you have given is justifiable.

    Other than the usal post installation steps (like SGEN, DB statistics etc..) you may refer note 987961 for important informations around I/O performance with SQL 2005.

    Regards,

    Manoj

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 27, 2008 at 01:57 PM

    Our system performance is much better after SAP help us

    Task Type Name DIALOG

    Date of Statistical Record 10/23/2008

    Number of Dialog Steps 27401

    Average Response Time/Dialog Setp(ms) 576.6

    Average Processing Time/Dialog Step (ms) 214.3

    Average CPU Time(ms) 67.5

    Average Database Time/Dialog Step (ms) 435.0

    Average Wait Time/Dialog Step (ms) 11.2

    Average Roll In Time (ms) 21.1

    Average Roll Wait Time (ms) 73.7

    Average Load and Generation Time (ms) 27192.8

    Average Lock Time/Dialog Step (ms) 1.1

    Average RFC Interface Time (ms) 12.7

    Average Frontend Network Time (ms) 99.4

    Average GUI Time/Dialog Step (ms) 96.7

    Number of Roundtrips 53725

    Requested data (KB) 4957590

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 31, 2008 at 08:32 PM

    Hi,

    Use transaction st03n to view the dialog workload overview.

    Regards,

    Rupali

    Add comment
    10|10000 characters needed characters exceeded