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

Chapter 5: Configuration and Operation 63
Copyright © 1999-2007 PolyServe, Inc. All rights reserved.
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.
Timeout and Failure Severity: This setting works with the Virtual SQL
Server policy (either
AUTOFAILBACK or NOFAILBACK) to determine what
happens when the SQL monitor probe fails.
The default policies (
NOFAILBACK for the Virtual SQL Server and
AUTORECOVER for the monitor) cause the ClusterPulse process to fail
over the Virtual SQL Server to a backup node. The Virtual SQL Server
remains on the backup node until a “healthier” node becomes available,
at which point the Virtual SQL Server will fail over to that node.