Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2009 Richard Kiessig
About this chapter
Cite this chapter
(2009). SQL Server Analysis Services. In: Ultra-Fast ASP.NET. Apress. https://doi.org/10.1007/978-1-4302-2384-9_9
Download citation
DOI: https://doi.org/10.1007/978-1-4302-2384-9_9
Publisher Name: Apress
Print ISBN: 978-1-4302-2383-2
Online ISBN: 978-1-4302-2384-9
eBook Packages: Professional and Applied ComputingApress Access BooksProfessional and Applied Computing (R0)