cancel
Showing results for 
Search instead for 
Did you mean: 

run time for queries

Former Member
0 Kudos

hello all,

how and from where do we get the runtimes, read and transfer times etc for a query. can anyone give me the steps with transaction codes pls.

Thanks in advance

S P

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

hi S P,

you can try ST03 -> 'expert mode' (click 'administrator' button, left top), then double click 'bw system load', you will see tab 'share of runtime', to check query runtime double click infoprovider name (where the query retrieve data.

hope this helps.

Former Member
0 Kudos

hi AHP,

thanks for your quick reply. I have got the runtimes now.

What are the different columns we have to look into on that screen.

Do we have any standards to compare those timings with, to know which of them is slow or fast.

Thanks

S P

0 Kudos

hi S P,

you can check 'total runtime' (in seconds).

%DB may useful in 'judging' whether aggregate will help or not, take a look following doc

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3f66ba90-0201-0010-ac8d-b61...

hope this helps.

Answers (3)

Answers (3)

Former Member
0 Kudos

Look also this helpfull blog:

/people/prakash.darji/blog/2006/01/27/query-creation-checklist

Regards

Former Member
0 Kudos

Hi,

goto theT.code: st03

ExportMode

there u will find the run time o f u Query

Hope it will Help, Other wise u have to run staticstic

Report( u Have to install)

Anil

Former Member
0 Kudos

Hi,

run transaction RSRT and enter your query. Choose "Execute and debug" and set flag for "Don't use cache" and "Show statistics". You can also enable option to select aggregate manually if you want to compare your aggregates...

Best regards,

Björn