Spotlight on SAP ASE 2.12 - Getting Started Guide

Installation

Installation Requirements

Before beginning the installation, review this section to ensure required privileges are set and system requirements are met.

Privileges Required for User ID

You must have the System Administrator (sa) user ID and password for the Adaptive Server you want to diagnose, or have a DBA setup a user ID by running the setup utility before you can use Spotlight to diagnose the Adaptive Server. All metrics are available to sa users. Non sa users can be set up to monitor a SAP Adaptive Server with a non sa setup utility shipped with the Spotlight® on SAP ASE. Nearly all metrics and features are available to non sa users.

Monitoring Tables for SAP ASE 15 or later

If an Adaptive Server 15 or later does not have the monitoring tables installed script, Spotlight cannot use the MDA API. Spotlight notifies you of this condition and breaks the connection to the Adaptive Server. You can install these table using the INSTALLMONTABLES script that is shipped with Adaptive Server.

System Requirements

Install or Upgrade Spotlight® on SAP ASE

To install Spotlight on SAP ASE Getting Started Guide

1. Run the Spotlight® on SAP ASEinstallation program from the CD or the download file.
2. At the Welcome screen of the setup wizard, click Next.

3. Select Simple for the Installation Type. Click Next.

   Note: The simple installation option is recommended. If a pre-existing Spotlight installation is installed, it is updated automatically. Selecting the Advanced option allows you to install into a separate directory structure from any other Spotlight installations.

   By default, Spotlight® on SAP ASE is installed into the following directory:

   C:\Program Files\Quest Software\Spotlight

4. Select I accept the license agreement.
5. Click Next.
6. Click Finish.

Silent Install of Spotlight® on SAP ASE

To silently install Spotlight® on SAP ASE:

Execute this command:

Spotlight_SAP_ASE_version.msi /qn

Where

/qn = quiet, no UI

To install it in a directory different from the default product directory

Spotlight_SAP_ASE_version.msi /qn

INSTALLDIR=destination_folder

Where

INSTALLDIR=destination_folder allows you to specify the directory path.