SAP BW .. TUNNING

Q.What are Oracle specific tuning should be done?Ans.
a. use sap note 180605 to set the right oracle DB parameters; this does improve performance and this note is updated continuously.
b.Use database statistics as described in SAP notes
c. Use database partitioning

Q.What are server relating tuning?Ans.
a.the right combination of resources like CPU, memory and disk spaces.
b.load balancing with server application servers
c.check for unnecessary traces and logs
Q.What are the web related tuning we can do?Ans.a. use HTTP conversion to reduce network traffic;
b.Use client browser caching.
c.use the eimon.exe programme and use the log file option to time the query.
d. use analyze iemon.exe to get CSV file to a spread sheet for further analysis.
Q.what are reporting performance we can do?Ans.
a.Aggregates
b.OLAP cache
c.Pre-caliculated web templates
d.Use small amount or result data as starting point of any querries and do the drill down
e.Avoid reporting on ODS
f. If you use exclusion in reporting(<>) , the indices are not used; so avoid using the exclusion, but use inclusion
g.Use the read mode “read when navigating and expanding hierarchies”
h.Use compression on info cubes since the E table is optimized for queries.
i.Create additional indexes
j.Run DB statistics often

Q.What are system tools you can use?Ans.
a. RSR T, RSRTRACE to debug and to explain plan statements on querries
b. ST05 for SQL traces
c. RSRV- to repair objects