on 10-23-2013 1:58 PM
Hello Experts,
How to do query performance checks in sap bi?
Regards
Ajai
hi,
go to RSRT screen and execute your query with execute+debug option, there by selecting and deselecting the check boxes like without bia, without aggregates etc..we can do analysis on querie performances.
regards,
anil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
The easiest way to check query performance (and the BW gold standard) is through transaction RSRT. Once inside RSRT, enter the query in which you would like to gather performance metrics on. You will then be prompted to tick or un tick a series of checkboxes based on what metrics you want returned or how you want the query to run.
For example, if you would like to see the BWA impact to a query you would check "do not use cache" and ensure that the "do not use BW Accelerator" is not checked. Then you may run it with the "do not use BW Accelerator" checked and "do not use cache" to see how much slower the query runs.
The performance metrics are displayed on the next screen once the query completes it's execution.
-----
Rob Davis
For more SAP BW/BI information check out my blogs:
Owner of SAPwebi.com and SAPBWtraininghq.com
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ajay,
Already bi related query perfomance issues was discussed in so many threads,
check it once in google .
for your reference check below threads once .
http://scn.sap.com/message/1182708
http://wiki.scn.sap.com/wiki/display/BI/How+to+Improve+Query+Performance+-+A+Checklist
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You posted in the BWA space, so I'm assuming you need to find info on TREX performance (BWA)?
If you mean normal BI/BW, then take a look at transaction ST14 if you have the ST tools installed at the BASIS level.
Regards,
Darryl
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.