3.1.2 Federated database server
- Organization of this subsection
(1) The system configuration of PFM - Agent for Microsoft SQL Server monitoring Microsoft SQL Server in a Federated database configuration
Federated database servers are cooperative group of databases which are joined together by horizontally partitioning the table across the nodes and thus creating a distributed partitioned view. Use this federated database server configuration when you make the group of the nodes cooperate so that you can process the data for a large Web site or a large company
Figure 3-2 shows a configuration for operating PFM - Agent for Microsoft SQL Server in a federated database configuration:
|
A Microsoft SQL Server system with a unique instance name is run on each node. PFM - Agent for Microsoft SQL Server monitors the Microsoft SQL Server instance on each node.
As with a single-node system, set up PFM - Agent for Microsoft SQL Server and configure it to monitor each node's Microsoft SQL Server Real Application Clusters instance.
Do not register PFM - Agent for Microsoft SQL Server in the cluster software.
- Note:
-
To operate PFM - Agent for Microsoft SQL Server in a federated database server and monitor the federated database server, handle PFM - Agent for Microsoft SQL Server as you would in a system with many single nodes. That is, handle it the same way as in a normal non-cluster system.