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

Master data file, Master log file, Error log file: These fields display the locations of the database and
log files.
Optional Components: When you add a SQL instance to a Virtual SQL Server, HP PolyServe Software
also creates a service monitor. This monitor periodically checks the health of the SQL service for this
instance. If the service monitor detects that its check has failed, by default the ClusterPulse process
(provided with Matrix Server) will fail over the Virtual SQL Server to a backup node. (You can use
the Advanced options to customize this behavior.)
NOTE:
A failure of the SQL Agent will not trigger a failover of the Virtual SQL Server.
When the service monitor detects that the SQL service is down, HP PolyServe Software can try to
restart the service instead of immediately failing over the Virtual SQL Server. The optional component
SQL Service Restart Attempts allows you to specify the number of attempts that should be made. If
you do not specify a number for this component, the Virtual SQL Server will fail over to a backup
node.
Probe Configuration: The SQL monitor periodically probes the health of the SQL Server service on the
node where the Virtual SQL Server is active. The frequency is the interval of time, in seconds, at which
the monitor runs the probe. The default setting is 20 seconds. The timeout is the maximum amount of
time that will be waited for the probe to complete. The default timeout interval is 15 seconds.
NOTE:
The probe behavior of the SQL service monitor differs from the default behavior of the service monitors
provided with Matrix Server. In Matrix Server, the monitor probes the associated service on all nodes
on which it is configured. The SQL monitor probes the SQL service only on the node where the Virtual
SQL Server is active.
NOTE:
A progress window will report each step as the SQL instance is virtualized. The step “Virtualize
<instance_name> on <node name> as primary” may take as long as five minutes to complete.
To add a Virtual SQL Instance from the command line, use this command:
mx vsqlinstance add <arguments> <vsql\instancename>
See the HP PolyServe Matrix Server command reference guide for information about the arguments.
View the Virtual SQL instances
The PolyServe Management Console shows the complete configuration of the Virtual SQL Server,
including the SQL service monitors created for the SQL instances associated with the virtual server.
The following example shows the Virtual Hosts tab.
Configure Virtual SQL Servers62