4.1.0 HP PolyServe Software for Microsoft SQL Server administration guide (T5392-96074, October 2010)

Stop the SQL Service ......................................................................................... 96
Database backups ............................................................................................. 96
Configure SQL Mail and SQL Agent Mail ............................................................. 97
Uninstall SQL Server instances ............................................................................ 97
6 Configure SQL Server Analysis Services ............................. 99
Overview ......................................................................................................... 99
Configure a Virtual SSAS .................................................................................... 99
DNS requirement for Virtual SSAS ................................................................. 99
Create a Virtual SSAS ............................................................................... 100
Progress reports .............................................................................................. 102
Add a Virtual SSAS instance ............................................................................. 103
Monitoring Virtual SSAS instances ..................................................................... 106
SQL Server Profiler .................................................................................... 106
Surface Area Configuration tool .................................................................. 106
Performance monitoring with perfmon .......................................................... 107
Rehost a Virtual SSAS ...................................................................................... 108
Other Virtual SSAS procedures .......................................................................... 110
Maintenance mode ................................................................................... 110
Add a new node to a Virtual SSAS ............................................................. 111
Virtual SSAS procedures ............................................................................ 111
Modify the configuration ..................................................................... 111
Enable/disable a Virtual SSAS ............................................................. 111
Delete a Virtual SSAS .......................................................................... 112
View status for a Virtual SSAS .............................................................. 112
Virtual SSAS instance procedures ................................................................ 112
Modify the configuration ..................................................................... 112
Disable or enable a Virtual SSAS instance ............................................. 112
Clear monitor errors ........................................................................... 113
Delete a Virtual SSAS instance ............................................................. 113
Revirtualize a Virtual SSAS instance ...................................................... 113
View status for a Virtual SSAS instance .................................................. 114
7 Using the Applications tab ............................................. 115
Overview ....................................................................................................... 115
SQL resources on the Application tab ................................................................. 115
Virtual SQL Servers and Virtual SQL instances .............................................. 115
Virtual SSAS and Virtual SSAS instances ...................................................... 116
Monitor errors .......................................................................................... 117
Manage the SQL configuration ......................................................................... 118
“Drag and drop” ...................................................................................... 118
Caution when using drag and drop ...................................................... 118
6