2.1.1 Preparation for installing and setting up PFM - RM for Microsoft SQL Server

Check the following items before installing and setting up PFM - RM for Microsoft SQL Server.

Organization of this subsection
(1) OS requirements
(2) Network environment settings
(3) OS user permission for installing PFM - RM for Microsoft SQL Server
(4) Prerequisite programs
(5) Installation and setup in a cluster system
(6) Preparation for collecting data when an error occurs
(7) Cautionary notes

(1) OS requirements

PFM - RM for Microsoft SQL Server can run on the following operating systems (OSs):

#
On Windows Server 2003 (x64) and the 64-bit version of Windows Server 2008, PFM - RM for Microsoft SQL Server operates on WOW64.

(2) Network environment settings

To operate PFM - RM for Microsoft SQL Server with Performance Management, you need to set the network environment such as the IP address or port number.

(a) IP address settings

When the OS is Windows Server 2008 R2 and Windows Server 2012, PFM - RM for Microsoft SQL Server can run in an IPv6 environment and dual stack environment in addition to an IPv4 environment.

In a Windows system, set up the environment so that an IP address can be resolved from the host name returned by the hostname command.For details about the configuration of a monitoring host name, see the chapter on installation and setup in the Job Management Partner 1/Performance Management Planning and Configuration Guide.Note that the IP addresses set in the jpchosts file are not used for the IP address resolving the addresses of monitoring targets.

Use one of the following methods to set the host name and IP address of a host monitored by Performance Management programs:

Use one of the following methods to set the host name and IP address of a host monitored by PFM - RM for Microsoft SQL Server:

Notes:
  • Although the Performance Management programs and PFM - RM for Microsoft SQL Server can operate in a DNS environment, they do not support host names in FQDN (Fully Qualified Domain Name) format. When you specify an IP address, use the host name returned by the hostname command after removing the domain name portion.
  • If you intend to use Performance Management within multiple LAN environments, set the IP addresses in the jpchosts file. For details, see the chapter on installation and setup in the Job Management Partner 1/Performance Management Planning and Configuration Guide.
  • Performance Management programs cannot operate on the hosts to which IP addresses are assigned dynamically by DHCP. Make sure that all the hosts on which Performance Management programs are installed are configured with user-specific static IP addresses.
(b) Settings when IPv6 used

Performance Management supports IPv6 environments as well as IPv4 environments as a network configuration. Therefore, Performance Management can operate even in a network configuration in which both an IPv4 environment and an IPv6 environment are used.

PFM - RM for Microsoft SQL Server can communicate with PFM - Manager via IPv6.

Note that this explanation applies only when the OS of a host on which PFM - RM for Microsoft SQL Server is installed is Windows Server 2008 R2 or Windows Server 2012, and the OS of a host on which PFM - Manager is installed is Windows Server 2008 R2, Windows Server 2012, or Linux.

For details about the scope of communication in an environment with both IPv4 and IPv6, see L. About Communication in IPv4 Environments and IPv6 Environments.

When you want to use IPv6 for communication, the settings for using IPv6 need to be enabled on both the PFM - Manager host and the PFM - RM host. You can specify the settings by executing the jpcconf ipv6 enable command. The following describes when the command needs to be executed and when it does not need to be executed.

Cases when the jpcconf ipv6 enable command needs to be executed:
  • When switching from an IPv4 environment to an IPv6 environment on each host
  • When switching the PFM - Manager environment from IPv4 to IPv6 in an environment in which both IPv4 and IPv6 are used
Cases when the jpcconf ipv6 enable command does not need to be executed:
  • When each host already operates in an IPv6 environment
  • When PFM - Manager operates in an IPv6 environment in an environment in which both IPv4 and IPv6 are used

The following shows an example of executing the jpcconf ipv6 enable command:

jpcconf ipv6 enable

For details about the jpcconf ipv6 enable command, see the chapter that describes commands in the manual Job Management Partner 1/Performance Management Reference. For details about the conditions or occasions for executing the jpcconf ipv6 enable command, see the chapter that describes network configuration examples in an environment that includes IPv6 in the Job Management Partner 1/Performance Management Planning and Configuration Guide.

When you use IPv6 for communication between a monitored host and PFM - RM for Microsoft SQL Server, specify the name of a monitored host where name resolution can be performed.

Communication between PFM - RM for Microsoft SQL Server and a monitoring target is performed with an IP address that can be resolved. Also, if an IPv4 environment and an IPv6 environment are both used, and communication between PFM - RM for Microsoft SQL Server and the monitoring target fails with an IP address that can be resolved, the communication is not retried by using another IP address.

For example, if communication fails when IPv4 is used, IPv6 is not used to retry communication. Similarly, if communication fails when IPv6 is used, IPv4 is not used to retry communication. Make sure beforehand that a connection can be established.

(c) Port number settings

The following table shows the default port numbers assigned to the services of Performance Management programs. For other services and programs, available port numbers are automatically assigned each time the services and programs are started. If you use Performance Management in a firewall environment, use fixed port numbers. For details about how to set fixed port numbers, see the chapter on installation and setup in the Job Management Partner 1/Performance Management Planning and Configuration Guide.

Table 2-1 Default port number of each service

Service descriptionService nameParameterPort numberRemarks
Service configuration information management functionName Serverjp1pcnsvr22285The port number used by the Name Server service of PFM - Manager. This port is set up on every Performance Management host.
OpenView linkage facilityNNM Object Managerjp1pcovsvr22292The port number used by the OpenView linkage facility of PFM - Manager and PFM - Base to provide communication between the map manager and object manager. This port is set up on the hosts on which PFM - Manager and PFM - Base are installed.
Service status management functionStatus Serverjp1pcstatsvr22350The port number used by the Status Server service of PFM - Manager and PFM - Base. This port is set up on the hosts on which PFM - Manager and PFM - Base are installed.
Monitoring console communication facilityView Serverjp1pcvsvr22286The port number used by the View Server service of PFM - Manager.
This port is set up on the hosts on which PFM - Manager is installed.
Web service facilityWeb Service--20358The port number used by the Web Service service of PFM - Web Console.
Web container facilityWeb Console--20359
20360
The port number used by the Web Console service of PFM - Web Console.
JP1/ITSLM linkage facilityJP1/ITSLM--20905The port number set by JP1/ITSLM.
Legend:
--: None

Ensure that the network is set up to allow communication using these port numbers, since they are used by PFM - RM for Microsoft SQL Server.

(3) OS user permission for installing PFM - RM for Microsoft SQL Server

When installing PFM - RM for Microsoft SQL Server, always use an account that belongs to the Administrators group.

(4) Prerequisite programs

This subsection describes the prerequisite programs for installing PFM - RM for Microsoft SQL Server.

The host on which PFM - RM for Microsoft SQL Server is installed is hereafter called "PFM - RM host".There are roughly two cases in the program configuration of PFM - RM for Microsoft SQL Server. The actual program configuration needs to be determined based on the system configuration.

Install PFM - RM for Microsoft SQL Server on the PFM - Manager host
This configuration is the program configuration for installing PFM - RM for Microsoft SQL Server on the same host on which PFM - Manager is installed. The following figure 2-1 shows the program configuration in this case:

Figure 2-1 Program configuration (Installation of PFM - RM for Microsoft SQL Server on the PFM - Manager host)

[Figure]
Install PFM - RM for Microsoft SQL Server on the different host from PFM - Manager host
This configuration is the program configuration for installing PFM - RM for Microsoft SQL Server on the different host from PFM - Manager host. In this program configuration, you need to install PFM - Base in advance on the same host on which PFM - RM for Microsoft SQL Server is installed. The following figure 2-2 shows the program configuration in this case:

Figure 2-2 Program configuration (installation of PFM - RM for Microsoft SQL Server on the same host on which PFM - Base is installed)

[Figure]
(a) Programs that can be monitored

PFM - RM for Microsoft SQL Server can monitor the following programs:

Windows Server 2003:
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2008 Enterprise Edition
  • Microsoft SQL Server 2008 Standard Edition
  • Microsoft SQL Server 2008 R2 Enterprise Edition
  • Microsoft SQL Server 2008 R2 Standard Edition
Windows Server 2008:
  • Microsoft SQL Server 2005 Enterprise Edition (SP2 or later)
  • Microsoft SQL Server 2005 Standard Edition (SP2 or later)
  • Microsoft SQL Server 2008 Enterprise Edition
  • Microsoft SQL Server 2008 Standard Edition
  • Microsoft SQL Server 2008 R2 Enterprise Edition
  • Microsoft SQL Server 2008 R2 Standard Edition
  • Microsoft SQL Server 2012 Enterprise Edition
  • Microsoft SQL Server 2012 Business Intelligence
  • Microsoft SQL Server 2012 Standard
(b) Performance Management programs

Install PFM - RM for Microsoft SQL Server and PFM - Base on the PFM - RM host. PFM - Base is a prerequisite program for PFM - RM for Microsoft SQL Server. Only one instance of PFM - Base is required, even when multiple instances of PFM - RM for Microsoft SQL Server are installed on one host.

Note that you do not need to install PFM - Base if PFM - Manager and PFM - RM for Microsoft SQL Server are installed on the same host.

To use PFM - RM for Microsoft SQL Server to monitor Microsoft SQL Server operation, PFM - Manager and PFM - Web Console are required.

(5) Installation and setup in a cluster system

When you install and set up PFM - RM in a cluster system, the prerequisite network environment and program configuration is different from those for a normal system. There are also additional tasks that must be performed on the executing nodes and standby nodes. For details, see 3. Operating PFM - RM for Microsoft SQL Server in a Cluster System.

(6) Preparation for collecting data when an error occurs

If a problem occurs, memory dumps, crash dumps, user mode process dumps, and other data might be required. To obtain these dumps when a problem has occurred, set output of these dumps in advance by using one of the following methods.

(a) Setting method for Windows Server 2003
(b) Setting method for Windows Server 2008

(7) Cautionary notes

Note the following when installing and setting up Performance Management.

(a) Note on environmental variable

Because Performance Management uses JPC_HOSTNAME as an environment variable, do not set it as a user-specific environment variable, as this will prevent Performance Management from operating properly.

(b) Notes on installing and setting up multiple Performance Management programs on one host

With Performance Management, you can install PFM - Manager, PFM - Web Console, and PFM - RM for Microsoft SQL Server on the same host. When doing so, note the following:

Point:
To improve system performance and reliability, we recommend running PFM - Manager, PFM - Web Console, and PFM - RM for Microsoft SQL Server on separate hosts.
(c) Notes on upgrading PFM - RM for Microsoft SQL Server

Note the following when upgrading PFM - RM for Microsoft SQL Server.

For details about upgrading, see the Appendix in the Job Management Partner 1/Performance Management Planning and Configuration Guide.

(d) Other cautionary notes