3.6.0 MxDB for SQL Server Installation and Administration Guide (5697-7088, December 2007)

Chapter 5: Configuration and Operation 62

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 PolyServe Matrix Server Command Reference 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.