Performace issue on ecc6.0

[Former Member]

Does any one upgrated SAP to ecc6.0? We encountered serious performace issure after upgrade. One of our program ran around 3-4 hours before upgrade. But now it runs over 15 hours. We did not change program. Any comments will be greatly apreciated.

MY

[Former Member]

Standard SAP program or custom? If custom, have you used the performance trace (ST05) to analyze it?

Rob

[Former Member]

Hi, Bob,

Thanks for the reply and advice. It is custom program. I never used ST05. For your experience, which trace (SQL, Enqueue, RFC, Table Buffer) and which Trace Function I can start with? I don't know what of ecc6.0 effected the performance. Thank you very much!

MY

[Former Member]

Try the SQL trace. It should show you if there are any bottlenecks and exactly where they are.

Rob

[Former Member]

OK. Thank you! I will try it and let you know if I can find something.

MY

[Former Member]

Hi, Bob and other expert,

Could you please tell me how to analize st05 result? I have a trace list. But I can not understand it. Thanks.

MY

[Former Member]

Basically, you're looking for any select statement that uses a lot more time than the others. In 4.6C, the first column is DURATION. This is the number of microseconds (I believe) that the operation took. Ones that take a long time are highlighted in pink.

Rob

[Former Member]

Hi !!

Left column you have a time spend by system to execute SQL command. Than database table used and command.

On command OPEN you can trigger explain button (on the toolbar). Now you can chec efficiency and strategies used for your sql statment. It is important for qureies to use keys and indexes !!!! On that screen look at the pagecount result. If you have very large summarized result ther sql comman may be slow.

BR, Jacek

P>S Plese reward helpful answers

Message was edited by: Jacek S³owikowski

Message was edited by: Jacek S³owikowski

[Former Member]

Hi, Jacek and Rob,

Thanks for replying so quickly. Actually I checked all the traces (SQL, Enqueue, RFC, and Table Buffer), because you know 15 hours running time is so terrible. Now, it seems SQL performance is not too bad. But I see some highlighted lines like this,

duration: 1,531,804

Op: client

statement: umqas_QAS_02 myang Client OLE_FLUSH_CALL 11,301 3,025

I don't know what does this mean. Also, I don't know where I can see the pagecount result. Thank you very much.

[Former Member]

I understand now. It seems RFC takes a lot of time.

[Former Member]

For the long running statements, there should be a button on the top where you can see the statement that was executed. (Put the cursor on the line first.)

Rob

[Former Member]

RFCs are time intensive. Check to see if you are doing this in a loop. If necessary, you should change the RFC to return all the data you need in one shot rather than calling it multiple times in a program.

Rob

[Former Member]

Hi, thanks for the advice. One more question.

On SQL trace, nothing has been highlighted by pink, but by yellow. Is it OK? All highlighted by pink are in RFC trace. I think Rob is correct. We need to think of it.

[Former Member]

BTW,

How can I reward point to you. I am new here. Thanks.

MY

[Former Member]

Yellow should be OK. I'd look at the RFCs first.

To assign points, close the thread etc. check the "Rules of Engagement". It's the first item on the first page of the forum topics.

Rob

[Former Member]

Thanks, Rob,

I read "Rules of Engagement". It says I can reward an answer by click star icon. But I don't see star icon. I see a star signal. I read the instuction again, but still don't know how to make that star signal to star icon. then to award. I am so sorry. I will take time read again tonight. But if you could give me a direction, that will be apreciated and save my time.

MY

[Former Member]

Next to each response, towards the top of each, there is a group of four radio buttons with text and a star. You just press the radio button that you think is appropriate for each response you got. I think it only allows you to assign one blue and two green stars and any number of yellow stars.

Rob

[Former Member]

Hi, Rob,

Thank you very much for answering my question so patient. But I really don't see four redio buttons. I only can see two. They are "Reply" and "E-mail this post" on the top of each response. And the star on the top is just a signal. Not a botton. Would you please give me a screen shot of what yours look like? Maybe I ask too much. But I really want to work this out. My email address is myang@olemiss.edu. Thank you very much!

Meiying

[Former Member]

On tha list of SQL trace:

Find a sql statment 'OPEN' .SEt the cursor on it. CLick tha button explain.

Detailed explenation of sql statment will be shown. An that screen you shoul find PAGECOUNT.

And one more. For check overall program performance (not only SQL's) use transaction SE30 !!!

BR, JAcek

P>S Plese reward helpful answers

[Former Member]

use ST05 for SQL trace ,check the background processes & log file at OS level