SQL Server Performance

Where are aggregations tables stored?

Discussion in 'Analysis Services/Data Warehousing' started by shahab03, Jul 25, 2006.

  1. shahab03 Member

    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
    Shahab
  2. Raulie New Member

    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.


    Regards

    Raulie



Share This Page