3.1.1 HA cluster system

There are two methods to operate PFM - RM for Microsoft SQL Server in an HA cluster system:

Operate PFM - RM for Microsoft SQL Server when Microsoft SQL Server Database operates in an HA cluster system.
Operate PFM - RM for Microsoft SQL Server in an HA cluster system.

The following describes the system configurations in each case.

Organization of this subsection

(1) The system configuration of PFM - RM for Microsoft SQL Server monitoring Microsoft SQL Server Database in an HA cluster system
(2) PFM - RM for Microsoft SQL Server configuration in an HA cluster system

(1) The system configuration of PFM - RM for Microsoft SQL Server monitoring Microsoft SQL Server Database in an HA cluster system

You can improve availability of a Microsoft SQL Server Database by using it in an HA cluster system, which can perform a failover if a failure occurs.

Typically, when you operate Microsoft SQL Server in an HA cluster system, you construct an environment that permits execution of the same Microsoft SQL Server instance on both an executing node and a standby node. The configuration you use stores a single set of Microsoft SQL Server data (data files, configuration files, log files, etc.) on a shared disk.

When you monitor Microsoft SQL Server in an HA cluster system by PFM - RM for Microsoft SQL Server, the network environment must be set up so that the host on which you install PFM - RM for Microsoft SQL Server can connect to the monitoring target Microsoft SQL Server host by its logical hostname and logical IP.

You can configure PFM - RM for Microsoft SQL Server as if PFM - RM for Microsoft SQL Server monitors a Microsoft SQL Server host in non-cluster system, when the monitoring target Microsoft SQL Server host is configured as in the following figures:

Figure 3‒1: Example of PFM - RM for Microsoft SQL Server monitoring Microsoft SQL Server in HA cluster system

There are also cases when the configuration or method of operating Microsoft SQL Server in a cluster system depends on the system.

To Page Top

(2) PFM - RM for Microsoft SQL Server configuration in an HA cluster system

PFM - RM for Microsoft SQL Server can operate in an HA cluster system and can monitor Microsoft SQL Server in a cluster configuration. Figure 3-2 shows a configuration for operating PFM - RM for Microsoft SQL Server in an HA cluster system.

Figure 3‒2: Example of an PFM - RM for Microsoft SQL Server configuration in an HA cluster system

As Figure 3-2 shows, PFM - RM for Microsoft SQL Server operates in a cluster system and monitors Microsoft SQL Server.

When a failure occurs, failover applies to PFM - RM for Microsoft SQL Server at the same time it applies to Microsoft SQL Server, allowing PFM - RM for Microsoft SQL Server to continue monitoring Microsoft SQL Server.

PFM - RM for Microsoft SQL Server also stores definition information about the shared disk and continues operating when a failover occurs. When there are multiple Performance Management programs on a single logical host, all programs use the same shared directories.

When you monitor multiple Microsoft SQL Servers, you can install PFM - RM for Microsoft SQL Server on separate logical hosts so that each PFM - RM for Microsoft SQL Server can operate and perform a failover independently.

To Page Top