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-3 shows a configuration for operating PFM - RM for Microsoft SQL Server in a federated database configuration:
Figure 3-3 Example of an PFM - RM for Microsoft SQL Server configuration in a federated database configuration
An Microsoft SQL Server system with a unique instance name is run on each node. PFM - RM for Microsoft SQL Server monitors the Microsoft SQL Server instance on each node.
As with a single-node system, set up PFM - RM for Microsoft SQL Server and configure it to monitor each node's Microsoft SQL Server Real Application Clusters instance.
Do not register PFM - RM for Microsoft SQL Server in the cluster software.