topic Re: Performace issue on ecc6.0 in Application Development and Automation Discussions

Performace issue on ecc6.0

Former Member — Wed, 28 Jun 2006 14:46:39 GMT

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.

Re: Performace issue on ecc6.0

Former Member — Wed, 28 Jun 2006 16:04:04 GMT

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

Rob

Re: Performace issue on ecc6.0

Former Member — Wed, 28 Jun 2006 16:22:19 GMT

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!

Re: Performace issue on ecc6.0

Former Member — Wed, 28 Jun 2006 16:25:49 GMT

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

Rob

Re: Performace issue on ecc6.0

Former Member — Wed, 28 Jun 2006 17:14:23 GMT

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

Re: Performace issue on ecc6.0

Former Member — Thu, 29 Jun 2006 13:50:28 GMT

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.

Re: Performace issue on ecc6.0

Former Member — Thu, 29 Jun 2006 13:58:45 GMT

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

Re: Performace issue on ecc6.0

Former Member — Thu, 29 Jun 2006 14:14:56 GMT

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

Re: Performace issue on ecc6.0

Former Member — Thu, 29 Jun 2006 14:35:43 GMT

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.

Re: Performace issue on ecc6.0

Former Member — Thu, 29 Jun 2006 14:41:20 GMT

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

Re: Performace issue on ecc6.0

Former Member — Thu, 29 Jun 2006 14:49:04 GMT

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

Re: Performace issue on ecc6.0

Former Member — Thu, 29 Jun 2006 14:52:30 GMT

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

Re: Performace issue on ecc6.0

Former Member — Thu, 29 Jun 2006 14:55:14 GMT

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

Re: Performace issue on ecc6.0

Former Member — Thu, 29 Jun 2006 15:14:52 GMT

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.

Re: Performace issue on ecc6.0

Former Member — Thu, 29 Jun 2006 15:17:22 GMT

BTW,

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

Re: Performace issue on ecc6.0

Former Member — Thu, 29 Jun 2006 16:09:35 GMT

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

Re: Performace issue on ecc6.0

Former Member — Thu, 29 Jun 2006 19:07:07 GMT

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.

Re: Performace issue on ecc6.0

Former Member — Thu, 29 Jun 2006 19:16:51 GMT

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

Re: Performace issue on ecc6.0

Former Member — Fri, 30 Jun 2006 15:44:38 GMT

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

Re: Performace issue on ecc6.0

Former Member — Fri, 19 Oct 2007 01:02:19 GMT

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