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

• 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.
To place a Virtual SQL Server in maintenance mode from the command line, use this command:
mx vsql maintain <vsql>
To return the Virtual SQL Server to operation mode, use this command:
mx vsql operate <vsql>
Create a notifier for the Registry Replicator
To assist with monitoring HP PolyServe Software, we recommend that you create a notifier for the
alerts generated by the Registry Replicator. (Alerts for the Registry Replicator are in the event range
40510 to 40516.) See the HP PolyServe Matrix Server administration guide for information about
configuring notifiers.
Change the network configuration
The SQL Server instance installation captures and stores the current IP network configuration of the
node on which it is installed. If you later need to change the network configuration (for example, to
remove a NIC or change its IP), it is necessary to devirtualize the Virtual SQL Servers configured on
the affected node, make the needed changes, and then revirtualize.
To devirtualize a Virtual SQL Server, you will need to delete it from the matrix configuration. Select
the Virtual SQL Server on the PolyServe Management Console, right-click, and select Delete. After
making your network changes, you can recreate the Virtual SQL Server.
Configure Virtual SQL Servers70