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

Add a Virtual SSAS instance ...................................................................................................... 92
Monitoring Virtual SSAS instances ............................................................................................... 94
SQL Server Profiler ............................................................................................................. 94
Surface Area Configuration tool ........................................................................................... 94
Performance monitoring with perfmon ................................................................................... 95
Rehost a Virtual SSAS ................................................................................................................ 95
Other Virtual SSAS procedures ................................................................................................... 97
Maintenance mode ............................................................................................................ 97
Add a new node to a Virtual SSAS ....................................................................................... 97
Virtual SSAS procedures ...................................................................................................... 98
Modify the configuration .............................................................................................. 98
Enable/disable a Virtual SSAS ...................................................................................... 98
Delete a Virtual SSAS ................................................................................................... 98
View status for a Virtual SSAS ....................................................................................... 98
Virtual SSAS instance procedures ......................................................................................... 99
Modify the configuration .............................................................................................. 99
Disable or enable a Virtual SSAS instance ...................................................................... 99
Clear monitor errors ..................................................................................................... 99
Delete a Virtual SSAS instance ...................................................................................... 99
Revirtualize a Virtual SSAS instance .............................................................................. 100
View status for a Virtual SSAS instance ......................................................................... 100
8 Using the Applications tab .............................................................. 101
Overview ............................................................................................................................... 101
SQL resources on the Application tab ........................................................................................ 101
Virtual SQL Servers and Virtual SQL instances ...................................................................... 101
Virtual MSDTC and Virtual MSDTC Service .......................................................................... 102
Virtual SSAS and Virtual SSAS instances ............................................................................. 103
Monitor errors .................................................................................................................. 104
Manage the SQL configuration ................................................................................................. 105
“Drag and drop” .............................................................................................................. 105
Caution when using drag and drop ............................................................................. 105
Select tasks from a menu ................................................................................................... 105
Virtual SQL Servers and Virtual SQL instances ............................................................... 106
Virtual MSDTC and Virtual MSDTC Service .................................................................... 106
Virtual SSAS and Virtual SSAS instances ....................................................................... 106
9 Instance Aliasing ........................................................................... 107
Overview ............................................................................................................................... 107
Instance Aliasing port considerations .................................................................................. 107
Move the mapping file ............................................................................................................ 107
Configure Instance Aliasing ...................................................................................................... 107
Configure Instance Aliasing settings .................................................................................... 108
Map default instances ....................................................................................................... 109
Map named instances ...................................................................................................... 110
Modify Instance Aliasing mappings .......................................................................................... 110
Delete Instance Aliasing mappings ............................................................................................ 111
Recommendations for monitoring Instance Aliasing ..................................................................... 111
Create a linked server ............................................................................................................. 111
10 Troubleshooting ........................................................................... 113
Install/uninstall issues .............................................................................................................. 113
SQL Server 2005 installation takes too long ........................................................................ 113
6