Chat now with support
Chat with Support

Spotlight on SAP ASE 2.11 - User Guide

Spotlight on SAP ASE
Background Information Desktop Features Connect to SAP ASE Spotlight® on SAP ASE Drilldowns Spotlight® on SAP ASE Alarms Glossary
Spotlight Basics
Spotlight Connections Monitor Spotlight Connections Alarms Charts, Grids And Home Page Components View | Options Troubleshooting
Spotlight History Spotlight on Windows
Connect to Windows Systems Background Information Home Page Alarms Drilldowns View | Options Troubleshooting
Spotlight on Unix About us Third-party contributions Copyright

I Cannot Open a Migrated Connection


Spotlight is unable to open a migrated connection.


When you open a Spotlight connection, you use connection details that are stored in files somewhere on your local computer or (in the case of migrated connections) somewhere on your network.

When Spotlight cannot access those connection details (for example, when the relevant network machine is unavailable), it displays a Spotlight message box that you can use to change the location where connection details are stored. The choices you have are:

Option Description


Click to open the Spotlight Migration wizard to change the location where connection details are stored.


Click to abandon the attempt to open the desired Spotlight connection.


Sometimes the network location that you have been using is only temporarily unavailable. Click to reuse the existing connection details to open a Spotlight connection.

Note: You should not migrate connections to locations that may be offline frequently or for extended periods. You cannot migrate connections that are currently in use or inaccessible.


Related Topics

High Spotlight Load on Database Server

The queries Spotlight uses to collect data can place an additional load on the system under diagnosis.

Most Spotlight queries consume a measurable but not significant amount of system resources. However, queries that are complex or collect large amounts of data may put a significant load on the system.

If you find that the load that Spotlight places on your server is too high, you can adjust collection rates for different categories of Spotlight data, and so limit the load that Spotlight places on the system under analysis.

To choose a standard Spotlight setting or create your own Custom settings

  1. Close and re-open Spotlight.
  2. Select File | Connect | Spotlight.
  3. Right click the Spotlight connection experiencing the high load and select Properties.
  4. Select Overhead.
  5. Adjust the Spotlight load for the connection:
    • Use the Overhead Management slider to adjust the overall Spotlight load.
    • Alternatively, click Custom… to adjust specific load categories.
  6. Open the Spotlight connection.

Main Window Hard To Read

The screen resolution is too low.

Increase the number of colors your computer is using. Spotlight requires a monitor that supports 65536 colors or higher (or Hi Color/16-bit) so that it can properly shade its graphs.

  1. Open the Windows Control panel and double-click Display.
  2. Click the Settings tab.
  3. Increase the number of colors in the palette. If this option is not available you should upgrade your hardware.

No Change to Data Flows

No Change to Data Flows

Either the refresh rate is too slow or Spotlight is paused. Do the following:

  • Update the screen. Click View | Refresh.
  • Check the foreground refresh rate setting (try a rate of approximately 30 seconds).

    To view / change the rate click View | Options and select Data collection | Data refresh rates

  • Resume Spotlight diagnostics. Click View | Resume. (If Resume is not available, Spotlight is not paused.)
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating