By default SQL Server has a pool of memory that is used to store both execution plans and data buffers. This pool of memory is managed by default within Analysis Services for SQL Server and such percentage of the pool allocated to either execution plans...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by
on
Sun, May 31 2009
Filed under:
Filed under: sql server, performance, data, cache, best practices, cube, Analysis Services, rolap, molap, proactive, advantage