Especially in a datawarehousing environment where the reports
run directly against the relational database, query performance
can be an issue and it is hence ideal for the data warehousing
team to invest some time in performance management.
It is also possible that end users are experiencing significant
delays in receiving their reports due to factors other than the
query performance. For example, network traffic, server configuration,
and even the way that the front-end was built sometimes play
significant roles.
Reliable Software can play a vital role in performance management and
can deliver an iterative solution with a proven methodology. We
approach the system in different dimensions as shown below
- Database tuning
- BI Tool optimization techniques
- Network Issues
- Platform/hardware configuration