Time taken to Execute code

[Former Member]

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

[Former Member]

Hello Expart,

Please help me to develop this requirment

Thanks,

Tarak

[former_member556412]

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

[Former Member]

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

[Former Member]

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

OR

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.

[RaymondGiuseppi]

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

Regards,

Raymond

[Former Member]

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

[Former Member]

>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.