SQL Server Performance

Analysis Services Installation

Discussion in 'SQL Server 2005 Analysis Services' started by gujsa01, Jan 21, 2008.

  1. gujsa01 New Member

    Hi,
    I have installed a new SQL 2005 EE cluster without Analysis services. Not having installed Analysis services in the past in a cluster environment, do I need seperate resources in terms of drives/volumes for the installation which cannot be shared with the data and log volumes?? My cluster is active/active.
    Appreciate any help at the earliest possible.
    Thanks!!
    gujsa01, Jan 21, 2008
    #2

  2. satya Moderator

    The install for Analysis Services 2005 is "cluster aware" so it will set itself up as a cluster resource and I think this is what you would want anyway as then SSAS could failover with other resources. On the resource you should be able to set it up with a dependancy or as part of a group so that it will move with a specific SQL instance in case of a failover. Following links should help you more:
    http://support.microsoft.com/kb/308023
    http://support.microsoft.com/kb/910230
    http://msdn2.microsoft.com/en-us/library/ms143511.aspx
    satya, Jan 22, 2008
    #3

Share This Page