Performance Tuning of Report without ST05 and SE30

[Former Member]

Hi All ,

I need to perfromance tune a Z report for a particular variant.

Issue : 1. No ST05 authorization avaliable.

2. When Report is executed online using SE30 for runtime analysis, error message time limit exceed is displayed.

Please let me know , how to do analysis of this object without using St05 and Se30.

I know that I can execute it in backgroung and get the actual time required for execution, but still I will not be able to get the cause of it.

Will report when scheduled in backgroung from Se30 , will give correct result ??

Is there any alternate approach avaliable to do the analysis.?

Thanks in Advance.

Edited by: Harsh Bhalla on Dec 23, 2009 12:15 PM

[Former Member]

Hi,

Since you dont have the authorization, check your code with the below tips/performance checklist in the below:

http://wiki.sdn.sap.com/wiki/display/ABAP/ABAPPerformanceand+Tuning

Thanks

Shiva

[former_member224008]

hi,

U also check the performance of Z program.

in SE38 Program->Check->Code Inspector

Regards,

Arun.

[Former Member]

In Backgroung that reports take 15- 13 min .

This is less than 20 min .

Then why is it showing time exceed error in SE30 ?

[ThomasZloch]

If you are a developer, you should have access to ST05, you can quote me

Time out occurs depending on system parameter settings, often set 5 or 10 minutes.

Can you run your program for a smaller selection, so that you can trace it with SE30 without timing out? Or run it in background and trace the active process.

Thomas

[former_member194613]

you can increase the time limit for the SE30 by yourself in the measurement restrictions, maximum is about 1:15 h, larger values are not possible because the number of microcseconds would exceed the limit of integer numbers. But this should still

be enough for your case.

You should ask for the authorization for the ST05.

Overall, if possible it is always better the run smaller examples, it is much better to trace two smaller examples with different sizes than one very large example.

Siegfried

[Former Member]

I don't suppose you have debugging authorization?

Rob

[Former Member]

Without proper authorization, not much luck I am afraid. The reason is simple: Performance trace puts load on the system, and that needs to be managed. So the best is to push for getting that authorization.... One other option may be to watch directly on the DB level (assuming of course it's a database issue, and you can get access via the DBA). there also are a few tools available on the after market, that do records all activities and write to a separate performance database, which you then can analyze at leisure.

Edited by: Lothar Schubert on Dec 24, 2009 1:30 AM