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

Chapter 5: Configuration and Operation 81

View Status for a Virtual SQL Server

The PolyServe Management Console shows the status of all Virtual SQL

Servers configured in the matrix. To view status from the command line,

use this command:

mx vsql status [--up|--down] [--operational|--maintenance]

[--primary|--backup] [--active|--inactive]

[--showApplication] <vsql>

Remove from Server Option

The Remove from Server option provided on the Management Console

should be used only under the direction of PolyServe Technical Support.

This option does not perform the necessary clean-up steps.

If you need to remove a server from a Virtual SQL Server configuration,

use one of these methods while all servers participating in the Virtual

SQL Server are up and running: Drag and Drop, the Rehost Virtual SQL

Server dialog, or the Virtual SQL Server Properties dialog.

Virtual SQL Instance Procedures

Modify the Configuration

To change the configuration of a SQL instance, select that instance on the

PolyServe Management Console, right-click, and select Properties. You

can then modify the configuration as necessary.

To modify the configuration from the command line, use this command:

mx vsqlinstance update <arguments> <vsql\instancename>

See the PolyServe Matrix Server Command Reference for more information

about the arguments.

Disable or Enable a SQL Service Monitor

When a monitor is disabled, the health of the server is affected in the

same manner as a failure of the monitor’s probe operation. If the Policy

configuration of the monitor is either

AUTORECOVER or

NOAUTORECOVER, the ClusterPulse process will attempt to fail over the

Virtual SQL Server to a backup node. If a backup node is not available or

if the Policy configuration of the monitor is

NOFAILOVER, the Virtual SQL