Page History

...

1. Click the "SQL Server Instance / <Host>,<Port>" drop-down menu and select the SQL Server instance.

   Info
   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.

   Info
   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 see see Adding a new server on page 44.

   Info
   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.

   Info
   When you want to delete the server, you will have to delete the dependent instances first before you are allowed to remove this server.

3. Click the "Connect using" drop-down menu and select the authentication type for the SQL Server.

   Info

   This is the authentication type the SQL Server Tier Collector will use to log in to the SQL Server instance. Select Windows Authentication to log in with the Windows user used to start the Precise for SQL Server service. Select SQL Server Authentication to log in with an existing SQL Server login name. To use Windows Authentication, you may need to change the user with which you log in to the Precise for SQL Server services (this means that this user needs to become the user who is defined in the SQL instance and has the Administrator permissions). If the Collector is installed on the monitored server, open the Services window and change the user with which you log in to the Precise for SQL Server Collector and the Precise Listener agent service. If the Collector is installed on a different server than the monitored instance, see step 6 below. When installing the Listener agent, you can choose to install all services with a dedicated Log In user.

4. Enter your Login name.

   Info
   If you connect using Windows Authentication, the login is based on the login used to start the Precise for SQL Server agents. If you choose SQL Server Authentication, an existing SQL Server user name and password with system administrator privileges are required here.

5. Enter the password.

6. If the PMDB is using Windows Authentication, or the Collector is using remote sampling, at the bottom of the screen, under "Use different Windows Service credentials than the LocalSystem account," enter accounts with the following permissions:
   Table 18-1 Permissions

   When	Permission	Where
   Remote sampling	User with full control permission	On the Precise folder
   	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

   To add the parameters

   1. On the Windows Authentication Settings screen, enter the user name.
   2. Enter the Password.
   3. Enter the Domain or Server name.
7. Click Next.

...

1. Open the PeopleSoft configuration file: psappsrv.cfg (usually under PT%version%/appserv/%domainName%). If EnableDBMonitoring=1, proceed to step 6. Otherwise, proceed to step 2.
2. Disconnect all PeopleSoft users.
3. Shut down all PeopleSoft servers.
4. Edit the DB Monitoring parameter to be TRUE:  EnableDBMonitoring=1
5. Restart the PeopleSoft application servers.
6. Using SQL Query Analyzer, connect to the database holding the PeopleSoft tables. Verify that you are connecting with a user that is a member of the db_owner database role in the database.
7. Execute the following batch:
             if exists (select name from sysobjects where name = 'precise_psprcsrqst_register' and type = 'TR')
             drop trigger precise_psprcsrqst_register go
             if exists (select name from sysobjects where name = 'VERITAS_psprcsrqst_register' and type = 'TR')
             drop trigger VERITAS_psprcsrqst_register go
             if exists (select name from sysobjects where name = 'Symantec_psprcsrqst_register' and type = 'TR')
             drop trigger Symantec_psprcsrqst_register go
             create trigger precise_psprcsrqst_register on PSPRCSRQST for update as
        declare @oprid char(30), @prcsinstance int, @old_status int, @new_status int, @info binary(50)
        select @old_status = RUNSTATUS from deleted select @new_status = RUNSTATUS from inserted if (@new_status <> 7) or (@old_status = 7) return
        select @oprid = OPRID, @prcsinstance = PRCSINSTANCE from inserted
        set @info = convert(binary(50), rtrim(@oprid) + ',' + convert(varchar(20), @prcsinstance))
        set context_info @info go

...

Save