C H A P T E R 9
SQL Server Analysis Services
In the previous chapter, you saw how aggregation queries, such as counts and sums, can have a significant adverse impact on the performance of a database. The problems arise partly because of the time it takes the relational database to step through each row in the tables involved and partly because of an increase in memory use. If the aggregation requires scanning a large table or index, the process can displace other buffers from memory so that SQL Server has to read them from disk again the next time another query needs them.
One way to improve the performance of aggregation queries is to cache their results. You can make the cached results available to all the servers in your web tier by using ...