performance tuning

[Former Member]

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

[Former Member]

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=....

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

[Former Member]

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

[Former Member]

Hi,

Check this link..

[original link is broken]

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

Regards,

Siva.