Page History
This section includes the following topics:• Pre
...
...
Based on your application, you can install special Collectors, called Interpoints that gather information on the activities and resource consumption of special application components. The Interpoints then correlate this information with MS SQL Server information so that you can see ERP users, transactions, reports, and so on.
You can install the following Interpoints:• Interpoint
- Interpoint for PeopleSoft
...
- Interpoint for SAP
...
- Interpoint for Siebel
See the appropriate section for installation of each Interpoint.
| Anchor | ||||
|---|---|---|---|---|
|
Most of the screens for this installation require you to input details regarding your information systems. Before performing this installation, compile a list of all required user inputs based on the procedures below.
Before installing a SQL Tier instance, verify that you have performed the following tasks:• Use
- Use the Precise Framework Installer to install framework components
...
- Create a Microsoft SQL Server login name with system administrator privileges and a password. This is optional for the SQL Server Tier; you may use the Microsoft Windows authentication option instead.
...
- If you intend to install SAP Interpoints, install the SAP Remote Function Call (RFC) client on the server that the SQL Server Tier Collector is installed on. Verify that the RFC functions STUM_WP_SERVER_ACTIVITY and TH_SERVER_LIST are enabled in your application. Define an additional working process within SAP to be used by the SAP Interpoints. This additional process will help avoid a queue of working processes that may be caused by an RFC call that SAP Interpoint executes through a specially allocated SAP working process. Create an SAP user account that the SAP extension will use to access the system. If you install Precise for SAP, you can use the same user as is used by Precise for SAP.
For more details on the required authorizations, see Pre-installation tasks on page 26.• Close
- Close the Services window in the Control Panel if you are installing on a Windows server.
...
- If you want to use the Recommend feature in Precise for SQL Server with different SQL Server versions, verify that all specific versions of the SQL Server clients are installed on the Precise for SQL Server FocalPoint server.
...
- When running the Collector in remote sampling mode, the Collector Windows Service credentials requires System Administrator privileges on the remote server (by default, the Collector service is run under the Local System account, which does not have privileges on other servers).
...
- If you are installing an MS SQL 2005 Collector on a Framework with an MS SQL 2008 PMDB, verify that MS SQL 2008 client tools are installed on the machine with MS SQL 2005.
...
| Anchor | ||||
|---|---|---|---|---|
|
This section describes the procedures that are needed to install a SQL Tier instance. You have the option of adding a new instance, as well as adding a new application. For information on editing or removing an existing instance, see Editing or removing Tier instances or clusters on page 200.
...
NOTE This is the name of the SQL Server instance you want to monitor. The list includes all instances that were detected in the Local Area Network. To monitor a different instance, type the instance name. SQL Server instances that contain the ‘$’ sign are not supported. If you choose a remote SQL Server instance, you will see the remote host server in the Servers list.
NOTE You can also insert an instance using the format "<host>,<port>", where <host> is the server name and <port> is the port of the SQL server instance. This is useful when the SQL Server browser service is disabled or deactivated.
2. Click the “Monitor SQL Server activity from this server” drop-down menu and select the server from the list. Click Add to enter the name of a server not on the list. For more information, see Adding a new server on page 44.
NOTE This is the server where you want to install the SQL Server Tier Collector. The server name or IP address appears in the list only if you previously defined it as a Precise server. You can install the Collector either on the sampled server, or on a remote server. If you wish to associate the Collector with Precise for Storage, you must install the Collector on the sampled server.
NOTE When you want to delete the server, you will have to delete the dependent instances first before you are allowed to remove this server.
...
User who is allowed to use Windows
Authentication
User with full control permission On the PMDB server
On the Precise folder
Remote sampling and PMDB using
Windows Authentication User who is allowed to use Windows
Authentication
User with full control permission On the PMDB server
On the Precise folder
PMDB uses Windows authentication and associating to Precise for Storage System Administrator On the monitored server
...
c. Enter the Domain or Server name.
7. Click Next.
About the AdminPoint Tier installation preview screen
...
Perform any tasks displayed on this screen. Click Execute for Precise to perform the action items. Click Mark as done if you have performed the action items yourself.
| Anchor | ||||
|---|---|---|---|---|
|
When the SQL Server Tier is installed, post-installation tasks may be required. This may depend on whether Precise for Storage or ERP Extension is installed.
...