SQL Server Performance

Olap Architecture

Discussion in 'Analysis Services/Data Warehousing' started by Mds203, Dec 8, 2004.

  1. Mds203 New Member

    Is it a good practice to migrate the Analysis Services Metadata to Sql server . IF so can i have the Sql Server on a seperate Box and not on the same as Analysis Services is installed .
    What are the best aggregation startergy that should be followed .
    Moh
  2. satya Moderator

    Which part of the Analaysis services you wanted to upgrade to SQL Server, I believe both are different services & components and may not be possible.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. thomas New Member

    Do you mean the repository? Yes, they can be on a seperate box, mine is. For performance reasons it's recommended not to have SQL Server and Analysis Services running on the same machine.

    Tom Pullen
    DBA, Oxfam GB
  4. satya Moderator

    Running both of them on same box, its a DBA's nightmare and as per MS suggestion its better to optimize the OLAP before setting it up, a thorough preview on books online would be ideal.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page