Chat now with support

Get Live Help
Complete Registration

Sign In

Request Pricing

Contact Sales

Spotlight on SAP ASE 2.12 - User Guide

Table of Contents

Spotlight on SAP ASE

Background Information

What is Spotlight® on SAP ASE? Features of Spotlight® on SAP ASE Freeware Version of Spotlight® on SAP ASE Review of SAP Adaptive Server Enterprise Architecture

Desktop Features

Main Spotlight® on SAP ASE Window

Users Panel Host Panel Network Packets Sent/Received ASE Panel Disk Writes/Disk Reads Data Cache/Procedure Cache Searches ASE Error Log Panel Backup Server Panel Memory Panel Data Cache Writes/Reads Procedure Cache Reads Disk Storage Panel

Spotlight® on SAP ASE Toolbar Spotlight® on SAP ASE Menus Spotlight® on SAP ASE Options Window

Connect to SAP ASE

Connect to an instance of SAP Adaptive Server Enterprise

Spotlight® on SAP ASE Drilldowns

Alarm Log drilldown Alarms by time drilldown Process Activity drilldown CPU Summary drilldown Database Summary drilldown Device Summary drilldown Error Log drilldown Memory Summary drilldown Network drilldown Server Configuration drilldown Cached SQL drilldown User Locks drilldown Threshold Event Log Change Event Log

Spotlight® on SAP ASE Alarms

Backup Server Status Alarm Blocked User Alarm Connections Used Alarm CPU Busy Alarm Data Cache Hit Rate Alarm Data Cache Reads Alarm Data Cache Searches Alarm Data Cache Writes Alarm Deadlocks Alarm Disk Reads Alarm Disk Writes Alarm Engines Offline Alarm Error Log Alarm Fullest Database Alarm Fullest Tempdb Alarm Fullest Transaction Log Alarm Host CPU Busy Alarm I/O Busy Alarm Locks Used Alarm Locks Waiting Alarm Open Databases Percent Alarm Open Indexes Percent Alarm Open Objects Percent Alarm Packets Received Alarm Packets Sent Alarm Problem Users Alarm Procedure Cache Hit Rate Alarm Procedure Cache Reads Alarm Procedure Cache Searches Alarm Response Time Alarm

Glossary

Spotlight Basics

Spotlight Connections

Spotlight Connection Manager Connection Properties

Connection Properties - General Page Connection Properties - Details Page Connection Properties - Overhead Page Custom Connection Performance

Migrate (Move And Share) Connections Connection Templates

Monitor Spotlight Connections

Spotlight Browser

Spotlight Browser Welcome to Spotlight Live connections All connections History Browser

Spotlight Home Pages Spotlight Drilldown Pages Spotlight Navigation Pause / Resume / Refresh Spotlight Favorites Spotlight Slideshow Connection Status bar Calibrate Connections

Spotlight Alarms Spotlight Today Alarms by Time Alarm Log Alarm Filters And Actions

Alarm Filters Ignore (Snooze) Alarms Custom Filter Rules Dialog Custom Filter Rules - Alarm Log Filter Dialog Alarm Actions - Alarm Log Filter Dialog Select the conditions for the alarm log rule

Where the action is... Where the alarm has (not) been active in the last n minutes Where the alarm has (not) been snoozed Where the alarm severity is... Where the connection is... Where the connection type is... Where the control is... Where the details contain... Where the highest alarm for the connection is... Where the value is...

Select the actions to perform

Play a sound Run a program Send e-mail to... Send network message to...

Alarm Metrics And Thresholds

About Alarms, Metrics, Thresholds And Severities Metrics Dialog Thresholds Dialog

Charts, Grids And Home Page Components

About Spotlight Charts Zoom in on Charts Pan Over Zoomed Charts Set the Chart View Filter on the Data Series Maximize and Restore Charts Chart Properties - Chart Page Chart Properties - Filtering Page

About Spotlight Grids Find Text Sort The Grid Tree View Show, Hide & Order Columns Select Multiple Rows Grid Properties - Options Page

Home Page Components

Spotlight Home Page Components Home Page Properties - Options Page

Restore Default Settings Copy To Clipboard Save To File Print Component Properties - Overhead Page

Configure Spotlight - View | Options Alarms and notifications

Alarm actions Alarm smoothing Balloon help E-mail server Taskbar

Chart configuration Color scheme Colors and flashing of alarms / Colors used in charts Slideshow

Data collection

Set the rate at which data is collected

Password storage

Navigation tree Initial view

Troubleshooting

Display performance

Troubleshooting

About Troubleshooting Product Authorization Errors I Cannot Open a Migrated Connection High Spotlight Load on Database Server Main Window Hard To Read No Change to Data Flows Disabled Controls Delay in Reporting Alarms Alarm Help Is Displayed Instead of The Drilldown Build the Support Bundle

Spotlight History

View | Options | Storage

Clear history History limits History location

Spotlight on Windows

Connect to Windows Systems Background Information

What Is Spotlight on Windows? Features of Spotlight on Windows An Overview of The Windows Architecture

Spotlight Home Page System Panel Network Panel Event Log Panel CPU Panel Memory Panel Paging Files Panel Disks Panel Files Panel

Spotlight Alarms Cache Reads Alarm Cache Writes Alarm Current Users Nearing Limit Alarm Diagnose Single Application Alarm Disk Alarm Disk Reads Alarm Disk Writes Alarm Event Log Alarm Logical Disk Statistics Alarm Low Memory Alarm Missing Performance Counters Alarm Network Failure Alarm Page Faults Alarm Page File Location Alarm Page Hits Alarm Page Outs Alarm Page Reads Alarm Page Writes Alarm Paging File Alarm Paging File Disk Location Alarm Percentage Bandwidth Alarm Physical Memory Usage Alarm Process CPU Utilization Alarm Processor Queue Length Alarm Read Hit Alarm System Up Time Alarm Total CPU Usage Alarm Virtual Address Space Alarm Virtual Memory Alarm Windows CPU Alarm WMI Statistics Alarm

Spotlight Drilldowns Processes Drilldown

Processes Page Process Details

Process Details Page Process History Page Process Threads Page

Services Page System Drivers Page

CPUs Page Processing Page Multiprocessor Page

Memory Drilldown

Summary Page Paging Activity Page Cache Page

Disks Drilldown

Logical Disk Activity Page Physical Disk Activity Page Logical Disk Space Usage Page Disk Summary Page File Sizes Page

Network Drilldown

Network Page TCPIP Page NBT Page SPX Page Sessions Page Shares Page

Shares Page Open Connections

Open Connections Page Permissions Page

Open Ports Page cLAN Gigabit Page

Activity Summary Event Log Single Application

Summary Page CPUs Page Memory Page Disks Page

Spotlight on Windows - View | Options Appearance

Windows Disks Metrics Windows Network Card Display

Data collection

Windows Applications Metrics Windows Event Log Metrics Windows Files Metrics

Troubleshooting

Troubleshooting Spotlight on Windows Issues Connecting

The Registry ... is not accessible. Network Name (Path) Not Found Connecting As The Logged-in User WMI Connection Problems

Issues Monitoring A Windows Machine

Display Problems on The Home Page Disks Panel And Disk Drilldown Display Problems on The Home Page Network Panel, Flows And Network Drilldown The Processes Page And Process Affinity Installing The SNMP Protocol

Spotlight on Windows License

Spotlight on Unix

Spotlight Home Page Background Information

What is Spotlight on Unix Features of Spotlight on Unix

Connect to Unix Systems

Configure the Unix System Connect to Unix Systems

Spotlight Home Page System Panel CPU Panel Memory Panel Swap Space Panel Network Panel Disk Activity Panel

Spotlight Alarms Blocked Process Alarm Input Error Packets Flow Alarm Output Error Packets Flow Alarm Page In Alarm Page Out Alarm Percentage Busy Alarm (Most Active Disk) Swap Space Alarm Swap In Flow Alarm Swap Out Flow Alarm Used Percentage Alarm Zombie Processes Alarm

Spotlight Drilldowns Processes and Services

Processes Page Process Details Page

Zombies Page Services page

Activity Summary

Activity Page Disk Page Memory Page CPU Page Network Page Logins Page

Filesystems And Disk Information Alarm Log

Spotlight on Unix - View | Options Appearance

Unix Filesystem Metric

Troubleshooting

Troubleshooting Spotlight on Unix Use Tracing To Add Details To Support Bundle iostat Not Installed Issues With Data Availability Authorize Spotlight

About us Third-party contributions Copyright

SQL Workarea graph

Agents have access to a SQL workarea where the working copy of any executable section is stored. In partitioned databases, all non-SMP agents share this area. In other environments and with SMP agents, each agent has its own unique SQL work area.

The following parameters control the size of the SQL workarea :

Agent Type/Environment	Configuration Parameter
Non-SMP agents in partitioned database environments	APP_CTL_HEAP_SZ
Agents in all other environments	APPLHEAPSZ
SMP agents in all environments	APPLHEAPSZ

The graph

The SQL Workarea graph contains a single series, Hit Rate, which plots the percentage of lookups in the SQL workarea that were satisfied by statement sections already residing in the work area.

The graph title area shows the number of SQL workarea inserts and lookups that occurred during the last monitoring interval.

For related statistical information

The Statistics tab contains entries for all the SQL workarea statistical counts used to generate this graph. The names for these statistics begin with Section. These statistics are derived from the APPL_SECTION data elements that the DB2 snapshot monitor captures.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating

© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center