on 08-09-2006 10:40 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
hope this helps.
Look also this helpfull blog:
/people/prakash.darji/blog/2006/01/27/query-creation-checklist
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.