3.4.3 MxDB for SQL Server Installation and Administration Guide

Chapter 3: Configuration and Operation 49

The frequency is the interval of time, in seconds, at which the monitor

runs the probe. The default setting is 20 seconds.

NOTE: The probe behavior of the SQL service monitor differs from the

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.

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.

Advanced Options for SQL Monitors

You can customize the operation of the SQL service monitor by using the

Advanced options provided on the Add Virtual SQL Instance window.

When you click the Advanced button, you will see two tabs: Policy and

Scripts.

Policy

The Policy tab lets you specify the failover policy and service priority that

will apply to the monitor.