3.1.1 HA cluster system
- Organization of this subsection
(1) The system configuration of PFM - Agent 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.
There are also cases when the configuration or method of operating Microsoft SQL Server in a cluster system depends on the system.
(2) PFM - Agent for Microsoft SQL Server configuration in an HA cluster system
PFM - Agent for Microsoft SQL Server can operate in an HA cluster system and can monitor Microsoft SQL Server in a cluster configuration. Figure 3-1 shows a configuration for operating PFM - Agent for Microsoft SQL Server in an HA cluster system.
|
As Figure 3-1 shows, PFM - Agent for Microsoft SQL Server operates in a cluster system and monitors Microsoft SQL Server.
When a failure occurs, failover applies to PFM - Agent for Microsoft SQL Server at the same time it applies to Microsoft SQL Server, allowing PFM - Agent for Microsoft SQL Server to continue monitoring Microsoft SQL Server.
PFM - Agent 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 - Agent for Microsoft SQL Server on separate logical hosts so that each PFM - Agent for Microsoft SQL Server can operate and perform a failover independently.