Hitachi

JP1 Version 12 JP1/Performance Management - Agent Option for Microsoft(R) SQL Server


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:

Figure 3‒2: Example of an PFM - Agent for Microsoft SQL Server configuration in a federated database configuration

[Figure]

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.