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.

Note:

To operate PFM - RM for Microsoft SQL Server in a federated database server and monitor the federated database server, handle PFM - RM 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.