topic Re: Long running reports in Application Development and Automation Discussions

Long running reports

Former Member — Tue, 09 Jan 2007 11:11:04 GMT

I need to find the long running reports in the system. Kindly give me a way to find the custom developments which are taking long run time.

Regards,

Karthik.k

Re: Long running reports

Former Member — Tue, 09 Jan 2007 11:18:30 GMT

Hi,

in SM50 you can find out the which reports are running long time.

i hope it will help you

kiran kumar.v

Re: Long running reports

Former Member — Tue, 09 Jan 2007 14:02:10 GMT

The SQL trace (ST05) is quite useful.

Rob

Re: Long running reports

RichHeilman — Tue, 09 Jan 2007 14:04:22 GMT

A good transaction to look at runtime statistics, is tcode STAT.

Regards,

Rich Heilman

Re: Long running reports

Former Member — Fri, 12 Jan 2007 04:02:22 GMT

Hi,

Execute the report RSORA245 with the following selection criteria one after other

Buffer gets = > 5,000,000

Disk reads =

Total execution =

Current Execution =

Shared memory =

SQL text =

Buffer gets =

Disk reads = > 2,000,000

Total execution =

Current Execution =

Shared memory =

SQL text =

Make a note of the program displayed in the above list. The above execution will give expensive SQL statements, which encompasses a lot of disk space and memory. The program name is displayed when you double click SQL statement and go for ABAP display. While updating the performance-monitoring sheet, also populate the SQL statement in findings along with name of program

In transaction ST03 , Click “Choose for analysis “ button .This will popup and screen in which one can select the application server on which the performance analysis is to be carried out .Now a pop-up for period for which the analysis is to be carried out.

Click “Top Time”. This report is already sorted on response time .If there are some report which has a reponce time more than 1,000,000 ms then this report is to be investigated further

Hope this helps.

Regards

Subramanian