4.0.0 HP PolyServe Software for Microsoft SQL Server Administration Guide (T5392-96056, March 2010)

Add a Virtual SSAS instance
Each Virtual SSAS can be associated with one SSAS instance. When assigning a SSAS instance to
a Virtual SSAS, you should be aware of the following:
• The Virtual SSAS must be active on its primary node and cannot be in maintenance mode.
To add a SSAS instance to a Virtual SSAS select the Virtual SSAS on the PolyServe Management
Console, right-click, and select Add Analysis Services Service.
Name: This field lists all of the SSAS instances that are available for assignment to this Virtual SSAS.
Select the appropriate SSAS instance.
NOTE:
HP PolyServe Software uses the following rules to determine the SSAS instances that can be assigned
to the Virtual SSAS. The Name field does not include instances that do not meet these requirements.
• The SSAS instance must exist on all of the nodes providing network interfaces for the Virtual SSAS.
(The instance must have the same name on all of the nodes.)
• The SSAS instance cannot be in use on any of the nodes as a primary for another Virtual SSAS.
• SSAS instance on the primary node cannot currently be a backup for another Virtual SSAS.
Virtual data root: Specify the full path for the PSFS filesystem that will be used for the data files and
directories for this SSAS instance. (In mx commands, the virtual data root is referred to as the vpath.)
Data path, Log path: These fields display the locations of the SSAS data and log files.
Optional Components: When you add a SSAS instance to a Virtual SSAS, HP PolyServe Software
creates a monitor that periodically checks whether the Analysis Services NT service is up and whether
the data path on the shared PSFS filesystem is accessible on the node hosting the Virtual SSAS. When
the monitor detects a failure of the NT service, HP PolyServe Software can try to restart the service
instead of immediately failing the Virtual SSAS over to the backup node. The optional component
Restart Attempts allows you to specify the number of attempts that should be made. The default is one
attempt.
Configure SQL Server Analysis Services92