Tuning Data Warehouse Performance

A data warehouse must provide rapid evaluation of queries that analyze and summarize huge numbers of rows of data from multiple joined tables. Microsoft® SQL Server™ 2000 provides information you can use to optimize the performance of the relational database that contains the data warehouse data. Database performance can be affected by many choices you make in the logical design of the database, its physical implementation, index tuning, query tuning, and so on. For more information, see Optimizing Database Performance Overview.

Although the performance of SQL Server 2000 Analysis Services depends to a large extent on the performance of the data warehouse database, its performance is also influenced by the design of the data warehouse database and the Analysis Services cubes. You can also tune the performance of Analysis Services by using tools that analyze usage patterns by adjusting the amount of aggregations that are precalculated when cubes are processed, optimizing cube schemas to avoid unnecessary joins, and so on. Computer hardware configurations also affect the performance of Analysis servers. For more information, see Analyzing and Optimizing Performance.