topic Re: Time taken to Execute code in Application Development and Automation Discussions

Time taken to Execute code

Former Member — Fri, 10 Jul 2009 08:00:44 GMT

Hi Expart,

I am developing a report in which i need

1.How long does CPU take to perform database SELECTs ( Need tables and fields to select)

2. How long does CPU take to perform certain calculations (to assess CPU performance )

Plz let me know the table name or procedure to get this information...

Thanks in Advance

Tarak

Moderator message - Please see before posting - post locked

Edited by: Rob Burbank on Jul 10, 2009 9:10 AM

Re: Time taken to Execute code

Former Member — Fri, 10 Jul 2009 08:11:45 GMT

Hello Expart,

Please help me to develop this requirment

Thanks,

Tarak

Re: Time taken to Execute code

former_member556412 — Fri, 10 Jul 2009 08:11:53 GMT

Hi,

You can use SE 30 to know the performance and usage of CPU.

and ST05 ( SQL Trace -> Activate trace) Run your program, Deactivate trace then display trace .

these ateps will let you know the performance of select queries.

Hope it helps.

Regards,

Bhanu

Re: Time taken to Execute code

Former Member — Fri, 10 Jul 2009 08:14:03 GMT

HI,

Either you can use ST05 for SQL trace for your program.

Or otherhand,

Use T.Code SE30.

Run your program and click on analysis button there.

YOu will get the compete details,

Regds,

Anil

Re: Time taken to Execute code

Former Member — Fri, 10 Jul 2009 09:19:08 GMT

Hi,

To troubleshoot performance, you need these tcode tools:-

ST04 u2013 Detail Analysis à SQL Request

ST02 u2013 SAP buffers

ST06 u2013 OS stats

ST05 u2013 SQL trace

SE30 u2013 Abap runtime analysis

few step which you can exercise to sort/identify performance issues.

ST03, ST02, ST04 are the tcode for workload, tuning and DB Performance Monitoring codes.

ST06 FOR Operation System Monitoring.

Check for top CPU in ST06 tcode. CPU should not exceed more than 60% for long time for any process.

Thanks.

Re: Time taken to Execute code

RaymondGiuseppi — Fri, 10 Jul 2009 09:32:24 GMT

Look at [Runtime Analysis|http://help.sap.com/saphelp_nw04s/helpdata/en/c6/617cafe68c11d2b2ab080009b43351/frameset.htm]

Regards,

Raymond

Re: Time taken to Execute code

Former Member — Fri, 10 Jul 2009 09:35:22 GMT

hi ,

Use SE30 (Runtime analysis tool) to analyse Your program to know performance and usage of your CPU

and use ST05 is the Performance Trace allows to record database access, locking activities, and remote calls of reports and transactions in a trace file and to display the performance log as a list. It also provides extensive support for analyzing individual trace records.

regards ,

Vijay

Edited by: vijay kumar pamulapati on Jul 10, 2009 11:35 AM

Edited by: vijay kumar pamulapati on Jul 10, 2009 11:36 AM

Re: Time taken to Execute code

Former Member — Fri, 10 Jul 2009 11:51:55 GMT

>in which i need

I would be careful with amateur measurements, but if you need it

use the command GET RUNTME inside the program


   GET RUNTME start. 
    ..... something done ....
   GET RUNTME stop.
  t = stop - start.