Spotlight on SAP ASE 2.12 - User Guide

I Cannot Open a Migrated Connection

Problem

Spotlight is unable to open a migrated connection.

Solution

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:

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

Troubleshooting

Migrate (Move And Share) Connections

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

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.)