How to do query performance checks in sap bi?

[Former Member]

Hello Experts,

How to do query performance checks in sap bi?

Regards

Ajai

[anil_babu13]

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

[Former Member]

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

[Former Member]

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 .

Business Intelligence Performance Tuning

http://scn.sap.com/message/1182708

http://wiki.scn.sap.com/wiki/display/BI/How+to+Improve+Query+Performance+-+A+Checklist

[former_member193518]

Hi,

You posted in the BWA space, so I'm assuming you need to find info on TREX performance (BWA)?

http://help.sap.com/saphelp_nw73ehp1/helpdata/en/fb/e92f428b10da2ce10000000a1550b0/content.htm?frame...

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

[Former Member]

Hi Darryl,

I need to know if there is any checklist to check the performance of the query.

list of different steps to check a query performance.

Regards

Ajai

[former_member193518]

Are you wanting to check a query in BW Accelerator (TREX) or in a normal BW system?

[Former Member]

In the BW system

Regs

Ajai