Spotlight on SAP ASE 2.12 - User Guide

Connect to an instance of SAP Adaptive Server Enterprise

Use this procedure to establish a connection with Adaptive Server instance. 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.

Before you connect

Before you begin the connection, the following must be in place:

• Ensure that the Adaptive Server is accessible to client applications.

• To utilize the full functionality of Spotlight® on SAP ASE to monitor your Adaptive Server instance requires using a login (defined in the Spotlight connection) with the following criteria:

  • For ASE versions 11.9.2.x, 12.0.x, and 12.5.0.x (prior to 12.5.0.3), either the "sa" or a login with the "sa_role". In addition, to see the SQL statements the account needs the "sybase_ts_role".

  • For ASE versions 12.5.0.3 and newer, the "sa" or a login with the "sa_role". In addition, the new role "mon_role" is needed for the account.

    Notes:

    • If you are unsure whether you have this access, contact your Database Administrator (DBA).
    • If your account does not meet the above criteria, Spotlight® on SAP ASE will not show several graphs and charts that monitor an ASE. (See Using Spotlight with a limited access login account).

Make the connection

To connect to SAP 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	Choose Spotlight® on SAP ASE from the drop-down list if it has not already been selected.
   New connection name	Choose a short and meaningful name for the new connection.

6. Click OK to save the details of the new connection, and create an icon for that connection in the Connection manager.

7. Complete the following fields in the New Connection Properties window.

   Field	Description
   ASE Server	The name of the Adaptive Server that is to be monitored. Note: If a client has been installed on the machine that Spotlight has been installed on, Spotlight attempts to find the SQL.INI file. If found, and the ASE Server is in that list, Spotlight will automatically complete the Host Name and Port fields.
   Host Name	The name of the specified host machine that the Adaptive Server is running on. Note: This corresponds to the host field in the SQL.INI file.
   Port	The port that the specified Adaptive Server is listening on. Note: This corresponds to the port field in the SQL.INI file
   Login Name	The login used to connect to the Adaptive Server. Note: Remember that using a login that is the ASE system administration (”r;sa”) or an account with the ”r;sa_role” and ”r;sso_role” will allow full monitoring of an Adaptive Server and automatically handle all issues for Spotlight to monitor the Adaptive Server. If using a non-sa account, then have a DBA follow the steps in the "Using a non- ”r;sa” Login" section in the Getting Started Guide 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 check box 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	Choose the type of Spotlight connection to make to the machine. The current set of options are Windows, Unix/SSH or Unix/Rexec. Note: 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 will use for its SSH (secure shell) connection to the UNIX host. The default value is 22.
   Save password details (for this connection)	Select this check box to save passwords whenever you add a new connection.

8. Click OK to create the connection.

Using Spotlight with a limited access login account

For Pre-ASE v12.5.0.3

Any data retrieved from ASE using the sysmon utility will not be available from within Spotlight.

1. Decide on the Login that will be used by Spotlight.

2. Contact your DBA, and have him run nonsasetup.exe located in the following path:

<Install Directory>\Spotlight\Plug-ins\SoSyb

Notes:

• This executable needs to be run to create some Spotlight stored procedures, to grant permissions on master sysengines, to add mon_role and other required roles to the login account and to set up SAP MDA API by turning on and tuning the respective server parameters.
• The nonsasetup.exe dialog box is shown below in "nonsasetup.exe Dialog Box".

For ASE v12.5.0.3 and newer

1. Decide on the Login that will be used by Spotlight.

2. Contact your DBA, and have him run nonsasetup.exe located in the following path:

<Install Directory>\Spotlight\Plug-ins\SoSyb

nonsasetup.exe Dialog Box

The nonsasetup.exe dialog box is shown below.

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

After you have entered the necessary information in the fields, press OK to begin setup.

A progress bar shows setup progress, and a message displays when setup is complete.

Press Close to close the application.

Spotlight® on SAP ASE Drilldowns

Drilldowns display detailed information about the system that you are diagnosing. Each drilldown contains a series of reports and graphs that provide you with specific information about the components of your system. The statistics that are available help you identify and anticipate performance problems.

The drilldowns listed below are specific to Spotlight® on SAP ASE. Other Spotlight applications will have their own individual drilldowns. For information on drilldowns in general, see Spotlight Basics.

For more information, see:

• Using the Cached SQL drilldown
• Using the Change Event Log drilldown
• Using the CPU Summary drilldown
• Using the Database Summary drilldown
• Using the Device Summary drilldown
• Using the Error Log drilldown
• Using the Memory Summary drilldown
• Using the Network drilldown
• Using the Spotlight Monitoring Requirements drilldown
• Using the Process Activity drilldown
• Using the User Locks drilldown
• Using the Threshold Event Log drilldown

Alarm Log drilldown

The Alarm Log drilldown provides access to information about alarms that have been raised for the current Spotlight on SAP ASE connection.

To display the Alarm Log drilldown

Click Alarm Log or press Ctrl + L.

The following is an example of the information that is displayed on the Alarm Log.

Alarms by time drilldown

The Alarm by time drilldown provides access to the Alarm Log alarms, that have been raised for the current Spotlight on SAP ASE connection, sorted by time.

To display the Alarm by time drilldown

Click Alarm by time or press Ctrl + T.

The following is an example of the information that is displayed on the Alarms by time log.