Spotlight® on SAP ASE is a Quest powerful diagnostic and problem resolution tool for SAP ASE. Its unique user interface provides you with an intuitive, visual representation of the activity on your database. Graphical flows illustrate the rate at which data moves between server components. Icons display the value of key statistics and measurements (metrics).
The power of Spotlight® on SAP ASE lies in its ability to provide visual and audible warnings if the performance metrics exceed acceptable thresholds. The components and data flows change color to show you the source of the problem.
A range of visual graphs and tabular grids provide you with detailed information about your ASE instance. This information can be viewed on the screen or printed.
You can set Spotlight® on SAP ASE to warn you when a threshold is reached. You may set a number of thresholds so that warning messages are displayed well before the traffic levels into or out of a database become critical. Spotlight uses a number of different techniques to warn you when your database is exceeding a threshold.
Spotlight® on SAP ASE seamlessly combines data from several different sources into a single user interface. It collects and combines data from ASE system tables and ASE commands and presents them in logically related screens.
When Spotlight® on SAP ASE detects a condition that it considers a potential problem, it not only informs you about it, but advises you what you could look at to diagnose the problem further, then suggests corrective actions.
Some of the main features and benefits of Spotlight® on SAP ASE are:
Detailed wait event monitoring
Improved SQL text and stored procedure monitoring
SoWin and SoUNIX integration
Provides a visual representation of process flows within ASE, allowing you to observe actual database and server activity in real time.
Visually identifies bottlenecks, and provides extensive drilldown capabilities.
Displays the details of problem areas, including active sessions, locks and deadlocks, disk I/O, and Windows server statistics for rapid problem resolution.
Provides visual and audible warnings to alert you when performance metrics exceed defined thresholds.
Provides detailed information about specific components through the use of drilldowns, allowing you to pinpoint the source or problems.
Assesses the normal rate of process flows via a calibration process, and adjusts the display speed of the visual indicators accordingly.
Has a quick and simple installation process.