topic Re: worst performing reports in Application Development and Automation Discussions

worst performing reports

Former Member — Tue, 17 Jun 2008 10:26:18 GMT

hi,

is there any transaction which i can use to find the list of all reports which are worst performing on ABAP and DATABASE level?

we are working on Performance optimization initiative.

so, we want to find out which all programs are hitting on performance level most..

i would prefer the list of all programs which are heavy on ABAP front as they are easy to fix, as they are caused by bad performing.

thanks in advance.

Re: worst performing reports

GauthamV — Tue, 17 Jun 2008 10:27:50 GMT

hi,

u can check the performance of programs using SE30 and ST05 transactions.

reward points if hlpful.

Re: worst performing reports

Former Member — Tue, 17 Jun 2008 10:28:30 GMT

Hi,

Try using STAD for this.

Thanks,

Sriram Ponna.

Re: worst performing reports

Former Member — Tue, 17 Jun 2008 10:30:03 GMT

Hi,

Check the link below :

http://www.thespot4sap.com/Articles/SAPABAPPerformanceTuning_PerformanceAnalysisTools.asp

hope it helps you very much as you are working on performance optimization initiative.

Regards,

Sharath

Re: worst performing reports

Former Member — Tue, 17 Jun 2008 10:32:03 GMT

Hi!

There is no such report, which could provide you runtime data from the programs.

You have to check them manually, or ask the users about problematic and slow reports.

You might check the CPU load with SM50 transaction.

You can check the memory usage in SM04 (Goto-Memory).

And there are stuffs in the Tools - Administration - Monitor SAP Menu.

Regards

Tamá

Re: worst performing reports

Former Member — Tue, 17 Jun 2008 11:23:39 GMT

hi,

thanks all, but i dont want to check run time for an individual report or any individual select query.

i want to check if there is any transaction which will give me the list of most time consuming reports IN A SYSTEM...

like if any reports are badly programmed they generally take more time.. but how to find such reports itself to fix them?

Re: worst performing reports

Former Member — Thu, 18 Nov 2010 08:54:35 GMT

CCMS is the best tool to analyse such things. I was not aware then.

Re: worst performing reports

Former Member — Thu, 18 Nov 2010 09:17:12 GMT

Dear ,

The best way for the same is

1, Get the

EARLY WATCH REPORT

of your system it will tell the ABAP program name 's that are are using most of your system resources and which are most frequently run.

If SAP solution manager early watch is not installed then call for SAP to help you for the same they will generate it for you.

Regards,

Gaurav Sood