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

Performance monitoring with perfmon
The Windows perfmon utility can be used to collect performance statistics for Virtual
SQL/SSAS instances based on the performance counters installed with SQL Server.
Virtual SQL/SSAS instances are monitored in the same manner as stand-alone
SQL/SSAS instances or instances installed on a MSCS cluster. You must have the
appropriate permissions to access the target server (via a physical or virtual hostname).
When connected, you can select the desired SQL counters to monitor.
Also note the following:
• Remote Registry Service must be running on the target node.
• You must have remote registry access right to browse the counter.
• Be sure to use the 64-bit version of perfmon to monitor 64-bit instances.
Other SQL Server procedures
Maintenance mode
When you need to apply a service pack or perform other SQL maintenance, you
can move a Virtual SQL Server to maintenance mode. This mode disconnects all
clients accessing the SQL instances associated with the Virtual SQL Server. The
associated SQL service monitors also stop probing on the primary node.
NOTE:
If an instance on a backup node is also being used as a backup for a primary
instance associated with a different Virtual SQL Server, that instance will no longer
have a backup. To minimize the time without a backup, we recommend that you
perform the maintenance on the backup instance first and then reenable the SQL
service monitor for that instance. The backup instance will then be available for the
other primary instance.
To move a Virtual SQL Server to maintenance mode, select the Virtual SQL Server
on the PolyServe Management Console, right-click, and select Maintain.
When you have completed the maintenance activities, you can return the Virtual SQL
Server to operation mode. Select the Virtual SQL Server on the PolyServe Management
Console, right-click, and select Operate.
Configure Virtual SQL Servers90