As a Sybase DBA, you need a real-time graphical display of the critical components in your database environment, and that’s exactly what Spotlight® on Sybase ASE provides. It gives you a clear view of I/O and user activity, enabling you to identify and eliminate bottlenecks faster than ever before. Plus, it eliminates many of your manual time-consuming tasks.
Before installing Spotlight for Sybase ASE, ensure your system meets the following minimum hardware and software requirements:
Language Supported:
Take a tour of Spotlight on Sybase ASE
Screenshots 1 of 13
The main Spotlight on Sybase ASE window provides a quick and intuitive view of the activity of a Sybase instance.
The Spotlight on Sybase ASE window helps you locate system bottlenecks quickly. Related server statistics are grouped together on panels that are connected by a series of graphical flow and icons. Spotlight on Sybase ASE updates these flows in real time so that you can see how quickly data is moving through the system. The icons change color as their values move through the range of thresholds.
The following graphic shows the main features of the Spotlight on Sybase ASE window.
The Alarm Log page displays a table of logged alarms for your defined Spotlight connections. When you first open the Alarms Log, the Connection control displays the name of the current connection.
The Database Summary drilldown provides access to information about:
The CPU Summary drilldown provides access to information about the amount of time the ASE spends on server-related tasks and the number of engines configured.
An important feature within Spotlight is the ability to display, collect and replay the behavior of a Spotlight connection at a specified point in time such as when an important alarm was raised.
The details shown via the History browser are identical in format to those displayed by Spotlight in its "live" state, so you can view historical data in the same way as you would view a live connection.