Spotlight on SAP ASE 2.12 - Getting Started Guide

Create Temporary Database

Spotlight® on SAP ASE relies on a temporary database and will use tempdb, the default temporary database, if you do not setup a temporary database for Spotlight to use. To prevent Spotlight from influencing the performance of the tempdb, it is recommended that you create a new temporary database and setup a dedicated user that uses this temporary database.

1. Create a new database device with 10MB size. It is best to create the new device on a physical disk which is different from the disk used by the existing tempdb.
2. Create a new temporary database which uses the newly created database device (8MB for data and 2MB for log).

3. Create a new user and bind to the newly created temporary database.

   e.g. sp_tempdb bind, lg, sosyb, DB, sosybtempdb

   Note: The device size is an initial recommended size and is based on our recommended monitoring table configuration parameters setting. You may need to increase the device size when those parameters sizes are increased.

The Spotlight Program Group

The Spotlight installation creates a program group called Spotlight on the Windows Start menu. Unless you change the default locations during installation, this group is located in All Programs | Quest Software.

Access Spotlight® on SAP ASE

To start Spotlight on SAP ASE Getting Started Guide

1. On the Windows taskbar, click Start | All Programs | Quest Software | Spotlight | Spotlight.

   

2. Select Spotlight® on SAP ASE in the Connections pane.

Connect to Adaptive Server Instance

Use this procedure to establish a connection with an Adaptive Server. Spotlight® on SAP ASE supports simultaneous connections to multiple servers. This eliminates the need to run concurrent versions of the application. Repeat the following procedure to connect to another server.

Creating a Spotlight User and a Connection

Using the “sa” Login

If the login you use has the “sa_role” and the “sso_role” (both recommended), then all monitoring metrics are available to Spotlight. For more information on a sa account, see Making the connection.

Using a non-“sa” Login

If the “sa_role” login is not used, several metrics in Adaptive Servers prior to version12.5.0.3 will not be displayed. In addition, you need your

Adaptive Server DBA to run the nonsasetup.exe utility shipped with Spotlight. The DBA needs to run this utility before monitoring the Adaptive Server with Spotlight can begin. This utility:

• Creates some Spotlight stored procedures.
• Checks/changes a few Server configuration parameters related to using ASE’s MDA API (ASE 2.5.0.3 and later).
• Grants the non-sa login some minimal privileges (i.e., “select” on master..sysengines and for the Adaptive Server 12.5.0.3 and later, the “mon_role” is added to the login).

For further information on a non-sa account, see the section titled Using Spotlight with a limited access login account.

Making the connection

To connect to Adaptive Server Enterprise

1. Start Spotlight® on SAP ASE.
2. Open the Spotlight Connection Manager.
3. Select Spotlight® on SAP ASE icon in the panel to the left.
4. Double-click the New Connection icon.

5. Complete the following fields in the New Connection window:

   Field	Description
   Select Connection Type	Select Spotlight® on SAP ASE from the list.
   New Connection Name	Select a short and meaningful name for the new

6. Click OK to open the ASE Properties window.

7. Complete the following fields in the Properties window:

   Field	Description
   ASE Server	The name of the Adaptive Server that is to be monitored. Spotlight attempts to find the SQL.INI file. If found, and the ASE Server is in that list, Spotlight automatically fills in the Host Name and Port Number.
   Host Name	The name of the specified host machine that the Adaptive Server is running on. This corresponds to the host field in the SQL.INI file.
   Port	The port that the specified Adaptive Server is listening on. This corresponds to the port field in the SQL.INI file.
   Login Name	The login used to connect to the Adaptive Server. Remember that using a login that is the ASE system administration (sa) or an account with the “sa_role” and “sso_role” allows full monitoring of an Adaptive Server and automatically handles all issues for Spotlight to monitor the Adaptive Server. If using a non-sa account, then have a DBA follow the steps in the section Using a non-“sa” Login before attempting to open this connection to the Adaptive Server.
   Password	The respective password for the login entered.
   Host Connection Details
   Monitor OS	Select this checkbox to monitor the operating system.
   Host username	The username you use when logging on to the machine.
   Host Password	The password you use when logging on to the machine.
   Host Type	Select the type of Spotlight connection to make to the machine. The current set of options are Windows, Unix/SSH or Unix/Rexec. If you are connecting to a UNIX host first make sure that Rexec or SSH is installed.
   Domain	If you are connecting to a Windows host, then the domain field is the name of the domain that the specified user belongs to. If no user name is entered in the Host username field, this field should also be left blank.
   Host port	If you are connecting to a Unix/SSH host, then enter the port number that Spotlight is to use for its SSH (secure shell) connection to the UNIX host. The default value is 22.
   Save password details	Select this checkbox to save passwords whenever you add a new connection.

8. Click OK.

Using Spotlight with a limited access login account

For Pre-ASE v12.5.0.3

Any data retrieved from Adaptive Server using the sysmon utility is not available from within Spotlight.

1. Decide on the login to be used by Spotlight.

   Note: This executable needs to be run to create some Spotlight stored procedures and to grant permissions on master..sysengines.

2. Request that your DBA run nonsasetup.exe, located in the following path:

   <Install Directory>/Quest Software/Spotlight/Plug-ins/SoSyb

   The nonsasetup.exe dialog box is shown in the section titled nonsasetup.exe Dialog Box.

For ASE v12.5.0.3 and later

1. Decide on a login for connecting to Adaptive Server from Spotlight.

2. Contact your DBA to run nonsasetup.exe located in the following path:

   <Install Directory>/Quest Software/Spotlight/Plug-ins/SoSyb

   Note: This executable needs to be run to create some Spotlight stored procedures, to grant permissions on master..sysengines, to add mon_role to the login account, and to set up ASE’s MDA API by turning on and tuning the respective server parameters.

nonsasetup.exe Dialog Box

The nonsasetup.exe dialog box is shown below.

The fields in this dialog are defined in the following table: