Skip to Content
avatar image
Former Member

How to do query performance checks in sap bi?

Hello Experts,

How to do query performance checks in sap bi?

Regards

Ajai

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Oct 23, 2013 at 01:08 PM

    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?frameset=/en/fb/e92f428b10da2ce10000000a1550b0/frameset.htm

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 24, 2013 at 12:52 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 28, 2013 at 01:43 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 04, 2013 at 08:53 AM

    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

    Add comment
    10|10000 characters needed characters exceeded