Chat now with support
Chat with Support

Spotlight on SAP ASE 2.11 - Release Notes

Release Notes

Spotlight® on SAP ASE 2.11.0

Release Notes

Friday, June 30, 2017

Welcome to Spotlight® on SAP ASE

Spotlight® on SAP ASE is a monitoring and diagnostic tool for SAP ASE administrators. Its unique user interface provides you with an intuitive, visual representation of database activity. Graphical flows illustrate the movement of information throughout the Adaptive Server. Icons and contextual drilldowns provide key statistics and metrics.

New in This Release

Quest Spotlight® on SAP® ASE 2.11.0 is a minor release.

Support for Encrypted Passwords

  • Spotlight on SAP ASE now supports Kerberos authentication for connections
  • Check Encrypt Password when creating a new connection for SAP ASE 15.7 and higher

Resolved Issues and Enhancements

The following is a list of issues addressed and enhancements implemented in this release.

Resolved Issue Defect ID
A bug causing Spotlight to log many errors to a log file was fixed 173

Known Issues

Feature Known Issue Defect ID
Connection Spotlight® on SAP ASE does not support connecting with a unicode username. ST104274
General Spotlight® on SAP ASE does not support installation of a Unicode directory. N/A
System processes are filtered out of the SQL Activity grid. As a result, SQL processes are also filtered out if the SQL was run prior to system monitoring and if the user is no longer logged in. N/A
The Total Wait Counts column under User Waits Activity resets and reports a negative count number for the "Spotlight" process ID.  
Install and Uninstall When Spotlight is uninstalled, any registry keys created by the application are not removed. See the Installation chapter of the Getting Started Guide for instructions to remove the Spotlight registry keys. ST69853

Third Party Known Issues

Feature Known Issue Defect ID
Cached SQL drilldown

Because of some limitations of SAP ASE show_condensed_text function the Cached SQL drilldown currently displays only 1020 characters.


System Requirements

Before installing Spotlight® on SAP ASE, ensure your system meets the following minimum hardware and software requirements:

Operating System

Windows Vista (32-bit or 64-bit)

Note: Recommended for monitoring local databases only.

Windows 7 (32-bit or 64-bit)

Windows 8 (32-bit or 64-bit)

Windows 8.1 (32-bit or 64-bit)

Windows Server 2012

Windows Server 2012 R2

Windows 10 (32-bit or 64-bit)

Windows Server 2016

Note: We recommend using an Administrator account to run Spotlight® on SAP ASE.

Memory 512 MB RAM (minimum); 1 GB (recommended)
Hard Disk Space 100 MB of free hard-disk space
Other requirements .NET 3.5 SP1
Database Server SAP ASE 15.0.2, 15.0.3, 15.5, 15.7, 16

Global Operations

This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.

This release is Unicode-enabled and supports any character set. In this release, all product components should be configured to use the same or compatible character encodings and should be installed to use the same locale and regional options. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America, Far-East Asia, Japan.

Getting Started

Contents of the Release Package

The Spotlight® on SAP ASE release package contains the following:

  • Spotlight® on SAP ASE 2.11.0
  • Product Documentation, including:
    • Getting Started Guide
    • Online Help
    • Release Notes

Product Licensing

Product Licensing

To license Spotlight® on SAP ASE, you need a license key and the site message.

Obtain the License

The required license key is delivered in one of three ways:

  • If you purchase Spotlight from a web site and have downloaded the product, you should receive an email with the license key and the site message shortly after the download has completed.
  • If Spotlight was delivered in a package, the license key and site message are included with that package.
  • If Spotlight was delivered as part of a trial, your sales representative should provide you with a license key.

If you do not get a license key, contact your sales representative.

Specify the license to authorize your use of Spotlight

After you have started Spotlight, you can authorize your use of Spotlight in one of two ways:

  • If you attempt to open a feature from the Spotlight console, Spotlight displays a message window that states that Spotlight® on SAP ASE is unlicensed. You can launch the authorization process from this message window.
  • You can launch the authorization process from the About Spotlight window.

To authorize your use of Spotlight from license message window

  1. From the message window that states you need to license Spotlight, click the Authorize button.
  2. On the Product Authorization window, provide the authorization (license) key, and then the site message.
  3. Click OK.

To authorize your use of Spotlight from the About Spotlight window

  1. From the Spotlight console, select Help | About Spotlight.
  2. On the Installed products tab, click View/change product license for Spotlight® on SAP ASE.
  3. On the License Viewer window, click Change this license for the installed version of Spotlight whose license you want to update.
  4. On the Product Authorization window, provide the authorization (license) key, and then the site message.
  5. Click OK to save the license information.
  6. Close the remaining windows.
Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating