Advanced installation of SQL Server tier collectors

This section includes the following topics:

• Defining the server upon which the FocalPoint is to be installed
• Sampling Alerts custom metrics from the monitored instance
• Defining the associated Precise for Storage
• Monitoring ERP

Defining the server upon which the FocalPoint is to be installed

The default location for the FocalPoint installation is on the same server as the Precise Framework. The General tab allows you to define a different server as the location for the FocalPoint installation.

To enter FocalPoint inputs

1. After adding all Tier installation instance properties inputs, click Advanced.
2. Click the General tab.
3. Click the drop-down menu and select the server which the FocalPoint should be installed upon.
4. Click OK.

Sampling Alerts custom metrics from the monitored instance

To enable sampling of Alerts custom metrics for this instance

1. After adding all Tier installation instance properties inputs, click Advanced.
2. Click the General tab.
3. Mark the box "Enable sampling of custom metrics for this instance."
4. Click OK.

Defining the associated Precise for Storage

Handling pre-installation tasks for EMC Storage

During the installation, Precise Agent Installer automatically checks if SYMAPI is installed, and which version (required is version 6.4 or higher). For more information, see the How to install and verify EMC Solutions Enabler in a Precise context technical note.

Pre-installation tasks for the Precise for Storage, HP XP version

To determine if the pre-installation tasks for Precise for Storage HP XP version have been performed, verify that HP Performance Advisor (XPPA) 1.06-2.2 is installed.

Defining the associated Precise for Storage

To define the associated Precise for Storage

1. After adding all Tier installation instance properties inputs, click Advanced.

2. Click the Storage tab.

   The SQL Server Tier Collectors can correlate I/O wait for applications with EMC, HP, and/or Windows storage devices. Select the relevant option below to get the additional storage data.

3. To be associated with the EMC file systems, choose "EMC" from the drop-down list.
   If the Storage type is EMC, select the SYMAPI database file name (the fully qualified file name of the SymmAPI database). To browse for the appropriate path and file name for EMC, click the browse (...) button.
4. To be associated with the HP file systems, choose "HP" from the drop-down list.
5. To be associated with the Windows file systems, choose "Windows" from the drop-down list.
6. Click OK.

Monitoring ERP

Entering ERP tab inputs for a SQL Server instance

Perform the following procedure in the order it is given.

To install SAP Interpoint for a SQL Server instance

1. After adding all Tier installation instance properties inputs, click Advanced.
2. Click the ERP tab.
3. Mark the box "Install SAP Interpoint on this instance."
4. Enter the SAP system name (the SID of the SAP instance to monitor which consists of three uppercase characters).
5. Enter the application server name to be used to connect to the SAP system.
6. Enter the system number (a two-digit system number of the application server).

7. Enter the user name.

   The SAP Interpoint uses this user name to connect to the SAP system for retrieving system information. Verify that you are using an SAP user name that you defined as part of the pre-installation tasks. For more information, see Pre-installation tasks on page 26.

8. Enter the password for the SAP user name.
9. Enter the name of the SAP system client that the user will use for the connection.

To install the PeopleSoft Interpoint for a SQL Server instance, check the box "Install the PeopleSoft Interpoint."

IDERA |  Products | Purchase | Support |  Community |  Resources |  About Us  | Legal

Save