BW system tuning

Added by Subbiah Mahalingam , last edited by Subbiah Mahalingam on Nov 08, 2007

BW SYSTEM TUNING
 
In an end user perspective, performance is nothing but, is the next logical dialog screen appears on his/her GUI without any long delay. If there is a delay, it appears to be a bad performing system. 
In a traditional way, performance tuning of an SAP application deals with buffer management, database tuning, work process tuning, fragmentation of the database, reorganization of the database, reducing I/O contention, operating system tuning, table stripping and the list goes on depending on the nature of the system.  
This document deals with more of performance tuning in a BW perspective rather than general R/3 parameter tuning. Like, query performance, data load performance, aggregate tuning etc. 
This document will focus the following key aspects in a detailed fashion.  
1.          What are the different ways to Tune an SAP system? ( General )
2.       What are the general settings we need to adapt in a good performing BW system?
3.       What are the factors which influence the performance on a BW system?
4.       What are the factors to consider while extracting data from source system?
5.       What are the factors to consider while loading the data?
6.       How to tune your queries?
7.        How to tune your aggregates?
8.       What are the different options in Oracle for a good performing BW system?
9.       What are the different tools available to tune a BW system? (With screenshots).
10.     What are the best practices we can follow in a BW system?

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/768773/viewspace-627543/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/768773/viewspace-627543/