SQL Server Performance Forum – Threads Archive
Where are aggregations tables stored?I found the following in books online Set Aggregation Options (Storage Design Wizard) Estimated storage reaches Enter the amount of hard disk storage to allocate for storing the aggregation tables. You can enter a maximum storage size in either megabytes (MB) or gigabytes (GB).
Now can anyone tell me where are aggregations tables actually stored at? Thanks
It depends what storage mode you choose, ROLAP aggregations are stored in the RDBMS, MOLAP and HOLAP aggregations are stored on the Analysis Server in the cube map files.