Spotlight on SAP ASE 2.11 - Getting Started Guide

Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Installation Requirements Install or Upgrade Spotlight® on SAP ASE Silent Install of Spotlight® on SAP ASE Uninstall Spotlight® on SAP ASE Removing Database Objects Register Spotlight® on SAP ASE

Configuration

Create Temporary Database The Spotlight Program Group Access Spotlight® on SAP ASE Connect to Adaptive Server Instance Troubleshoot Spotlight® on SAP ASE

Welcome to Spotlight® on SAP ASE

Features of Spotlight® on SAP ASE Spotlight Concepts

Using Spotlight® on SAP ASE

The Main Spotlight® on SAP ASE Window Spotlight® on SAP ASE Alarms Spotlight® on SAP ASE Drilldowns

Database Analysis drilldown Details tab

The Details tab on the Database Analysis drilldown provides the following:

Identification information for the selected database
Key statistics that provide an overview of database activities.

Database details and statistics

The following lists the details and statistics that appear on the Details tab for the selected database or database partition. Click a specific detail for its description.

Database Name	Connections Current	I/O Threshold Cleaners Triggered
Database Status	Connection Max Concurrent	OLAP Total Functions
Database Server	Locks Held	OLAP Active Functions
Database Location	Locks Waiting	OLAP Function Overflows
Database Path	Sort Heap Allocated	RTS - Stats Cache Size
Catalog Node Number	Lock List Used ( kb )	RTS - Stats Fabrications
Catalog Node Name	Database First Connect	RTS - Synchronous Runstats
Oldest Application Agent	Database Last Backup	RTS - Asynchronous Runstats
Log Secondaries Allocated	Database Statistics Reset	RTS - Fabrication Time (msec)
Log Max Secondaries Used	Log Space Cleaners Triggered	RTS - Sync Runstats Time (msec)
Log Usage(% )	I/O Victim Cleaners Triggered	Threshold Violations

Database Times Graph

The Database Times graph provides a visual overview of the amount of time spent on various processing events for the database or database partition. The times are displayed in seconds.