Skip to Content
author's profile photo Former Member
0
Former Member

performance tuning

Posted on Jul 28, 2007 at 09:35 PM 8 Views

Hi guys can any one tell me where you are going to do performance tuning exactly in SAP BW and can any one please provide the material for that

Thanks,

kumar

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 28, 2007 at 09:45 PM
    0

    Hi,

    Check this link..

    Business Intelligence Performance Tuning [original link is broken]

    https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/afbad390-0201-0010-daa4-9ef0168d41b6

    Regards,

    Siva.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 29, 2007 at 10:33 AM
    0

    HI

    Kumar

    Performance tuning is done mostly for these 2 cases.

    1, Improve query performance.

    2, Improve data loading time.

    When it comes to performance for querys, there are lot of options

    creating aggregates, precalculation of web templates, partition of cube etc , RSRT is a very usefull tcode to improve the query perormance.

    When it comes to loading there are lot of ways to improve the load time depending upon the problem you are facing

    Hope this helps

    K.Mohan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 03:17 PM
    0

    Our book on BW performance tuning has a detailed explanation and recommendations regarding step by step process of how to do the performance tuning. Pl. refer to the following link to know about the book.

    http://www.amazon.com/SAP-Performance-Tuning-Shreekant-Shiralkar/dp/0977725146/ref=sr_1_1?ie=UTF8&s=books&qid=1196767811&sr=1-1.

    You will notice that the book has screen shots and detailed theory on aspects like indexes like B Tree Index or Bitmap Index to help you identify and improve perfromance of your BW system.

    Thanking you in advance for sharing your feedback on the book and its "reference" value for your work.

    Shreekant

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.