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

Port: Enter the port number for TCP/IP Sockets that the SQL Server instance should
listen on. Specifying a port is required.
Virtual data root: Specify the full path that will be used for the data files and
directories for this virtual SQL Server instance. This location will store the SQL Data
Root that was created when the SQL Server instance was installed. (In mx commands,
the virtual data root is referred to as the vpath.)
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.
HP PolyServe Software for Microsoft SQL Server 4.1 administration guide 79