Spotlight on Sybase ASE

Sybase monitoring tool that provides real-time diagnostics

Identify and eliminate Sybase bottlenecks faster than you can imagine.

Detect and eliminate bottlenecks faster than ever, plus eradicate many manual, time-consuming tasks. Spotlight on Sybase offers you real-time graphical displays of the important components in your database, giving you a clear view of I/O and user activity.

Features

  • Get a real-time look at database and operating system activity through a unique graphical interface
  • Identify problem users based on CPU utilization, I/O utilization or blocking processes
  • Use the history browser to record and replay performance diagnostics
  • Stop having to manually calibrate alert levels for each adaptive server
  • Accelerate time to resolution with proactive alerts for detailed diagnostics and quick resolution
  • Oversee multiple Sybase adaptive servers at once

Specifications

Before installing Spotlight for Sybase ASE, ensure your system meets the following minimum hardware and software requirements:

Platform233 MHZ minimum
Memory128 MB of RAM minimum; 256 MB of RAM recommended
Hard disk space50MB
Monitor1280 x 1024 or higher
Sound card and speakers For threshold alerts.
Operating systemWindows® XP (Service Pack 3 or later), Windows® Server 2003 R2 and 2012, Windows® Vista, Windows® 7, Windows® 2008 and 2008 R2, Windows® 8 and 8.1 (32-Bit and 64-Bit)
Database clientThe installation program will install a database client if one is not installed.
Database serverSybase® Adaptive Server 11.9.2 or later

Application virtualization support

Citrix® XenApp® 6.5 on Windows Server 2008 R2.

Note: Spotlight may work in additional virtualization environments.

Language supported:

  • US English

Screenshots

loading

Spotlight on Sybase ASE

Take a tour of key functionality in Spotlight on Sybase ASE interface to experience its capabilities and ease of use.

Take a Screenshot Tour

Spotlight on Sybase ASE - Main Spotlight on Sybase ASE window

Spotlight on Sybase ASE Main Spotlight on Sybase ASE Window

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.

Spotlight on Sybase ASE - Alarm log

Spotlight on Sybase ASE Alarm Log

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.

You can:
  • View alarms for a specific connection.
  • Filter the Alarm Log table so that all, some, or none of these alarms are displayed.

Spotlight on Sybase ASE - Database

Spotlight on Sybase ASE Database

The Database Summary drilldown provides access to information about:

  • Number of databases
  • Size of the fullest database, transaction log, and temp DB being monitored
  • Percentage of space being used by the fullest database, transaction log, and temp DB being monitored

Spotlight on Sybase ASE - Engine_CPU

Spotlight on Sybase ASE Engine_CPU

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.

Spotlight on Sybase ASE - Engine_Wait

Spotlight on Sybase ASE Engine_Wait

The Wait Summary sub-page provides charts that illustrate details for the following:

  • Server Wait Count - The total number of wait events for the adaptive server.
  • Server Wait Time (msec) - The amount of time the adaptive server has spent in a wait state.
  • Engine Wait Count - Comparison of the number of times processes have waited on respective engines.
  • Engine Wait Time (sec) - Comparison of the amount of time processes have spent waiting on respective engines.

Spotlight on Sybase ASE - Error_Log

Spotlight on Sybase ASE Error_Log

The Error Log drilldown provides access to details about error messages for the ASE you are diagnosing.

Spotlight on Sybase ASE - History browser

Spotlight on Sybase ASE HistoryBrowser

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.

Spotlight on Sybase ASE - Lock_Lock/DeadLock

Spotlight on Sybase ASE Lock_Lock/DeadLock

The User Locks drilldown provides access to information about the number of lock waits that exceed the Lock Wait threshold, the number of locks in use, and the number of deadlocks detected on the ASE.

Spotlight on Sybase ASE - Lock_Lock/DeadLock

Spotlight on Sybase ASE Lock_Lock/DeadLock

The User Locks drilldown provides access to information about the number of lock waits that exceed the Lock Wait threshold, the number of locks in use, and the number of deadlocks detected on the ASE.

Spotlight on Sybase ASE - Network drilldown

Spotlight on Sybase ASE Network

The Network drilldown provides access to information about the number of packets sent and received by the ASE.

Spotlight on Sybase ASE - ServerConfig

Spotlight on Sybase ASE ServerConfig

The Server Configuration drilldown provides general information about the server machine including login, settings for ASE configuration elements, alarms, and error logs.

Spotlight on Sybase ASE - UserPerformance/UserWaitEvent

Spotlight on Sybase ASE - UserPerformance/UserWaitEvent

The Process Activity drilldown provides access to details of user connections, problem users, and processes running on an ASE.

Spotlight on Sybase ASE - UserPerformance/UserWaitEvent

Spotlight on Sybase ASE UserPerformance/UserWaitEvent

The Process Activity drilldown provides access to details of user connections, problem users, and processes running on an ASE.