Spotlight on SAP ASE
Background Information
Spotlight Basics
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
Connect to SAP ASE
Spotlight® on SAP ASE Drilldowns
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
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 Connections
Spotlight History
Spotlight on Windows
Spotlight Connection Manager
Connection Properties
Monitor Spotlight Connections
Connection Properties - General Page
Connection Properties - Details Page
Connection Properties - Overhead Page
Custom Connection Performance
Migrate (Move And Share) Connections
Connection Templates
Spotlight Browser
Spotlight Home Pages
Spotlight Drilldown Pages
Spotlight Navigation
Pause / Resume / Refresh
Spotlight Favorites
Spotlight Slideshow
Connection Status bar
Calibrate Connections
Alarms
Spotlight Alarms
Spotlight Today
Alarms by Time
Alarm Log
Alarm Filters And Actions
Charts, Grids And Home Page Components
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
Alarm Metrics And Thresholds
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
Charts
View | Options
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
Grids
About Spotlight Grids
Find Text
Sort The Grid
Tree View
Show, Hide & Order Columns
Select Multiple Rows
Grid Properties - Options Page
Home Page Components
Restore Default Settings
Copy To Clipboard
Save To File
Print
Component Properties - Overhead Page
Configure Spotlight - View | Options
Alarms and notifications
Appearance
Data collection
Security
Start-up
Troubleshooting
Troubleshooting
Connect to Windows Systems
Background Information
Spotlight on Unix
What Is Spotlight on Windows?
Features of Spotlight on Windows
An Overview of The Windows Architecture
Home Page
Spotlight Home Page
System Panel
Network Panel
Event Log Panel
CPU Panel
Memory Panel
Paging Files Panel
Disks Panel
Files Panel
Alarms
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
Drilldowns
Spotlight Drilldowns
Processes Drilldown
CPUs Drilldown
Memory Drilldown
Disks Drilldown
View | Options
Troubleshooting
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
Open Ports Page
cLAN Gigabit Page
Activity Summary
Event Log
Single Application
Alarm Log
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 Home Page
Background Information
Connect to Unix Systems
Home Page
About us
Third-party contributions
Copyright
Spotlight Home Page
System Panel
CPU Panel
Memory Panel
Swap Space Panel
Network Panel
Disk Activity Panel
Alarms
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
Drilldowns
Spotlight Drilldowns
Processes and Services
Activity Summary
Filesystems And Disk Information
Alarm Log
View | Options
Troubleshooting
Activity Page
The Activity page contains several charts.
To open the Activity page
- Select the Spotlight on Unix connection in the Spotlight Browser.
-
Click Activity Summary | Activity.
Charts on the Activity page
Notes:
- Every chart has a legend (list of symbols) to its right that describes the various series (line graphs) on the chart.
- Click an item in the legend to highlight its series (line) in the chart. Click a second time to return the series to its normal appearance.
- Move the mouse pointer over an item in the legend to view the current value for that series within the chart.
| Chart | Description | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| CPU Utilization | The CPU Utilization chart shows the CPU activity of the host machine. If the current activity reaches levels of greater than 100 or less than 0, run vmstat(1) to determine the reason for the erroneous values. | ||||||||||
| Run Queue |
The Run Queue chart shows the amount of CPU time that will be spent performing tasks. The value is expressed as a fraction. Divide the value by the number of processors running. If the result of the calculation is greater than 1, you may need more processors. The lines on the chart show the run queue averaged over 1, 5, and 15 minutes. If the value of the 1 minute line divided by the number of processors exceeds the value 1, there is merely a spike in activity. However, if the value of the 15 minute line divided by the number of processors exceeds 1, you may need more processors. | ||||||||||
| Total Disk I/O | The Total Disk I/O chart shows the total number of I/O operations for each disk and NFS server. | ||||||||||
| Network Utilization | The Network Utilization chart represents the current network activity for the machine you are diagnosing. It shows the rate at which packets are being received by the machine and are being sent by the machine. | ||||||||||
| Paging |
The Paging chart shows the rate of data pages read from, and written out to, disk over time. Typically, high paging rates indicate insufficient system memory, a large number of processes, or a number of very large processes. The unit of measure on the Y-axis is dependent on the Operating System.
| ||||||||||
| Free Memory | The Free Memory chart shows the amount of available physical memory in the machine. For Solaris, this is typically a low number. If necessary, the page-stealing daemon will seek out memory pages to re-claim them. |
Disk Page
The Disk page contains several charts.
To open the Disk page
- Select the Spotlight on Unix connection in the Spotlight Browser.
-
Click Activity Summary | Disk.
To view charts on the Disk page
Right-click the Disk page and select View as Chart.
Notes:
- Every chart has a legend (list of symbols) to its right that describes the various series (line graphs) on the chart.
- Click an item in the legend to highlight its series (line) in the chart. Click a second time to return the series to its normal appearance.
- Move the mouse pointer over an item in the legend to view the current value for that series within the chart.
| Chart | Description |
|---|---|
| Disk Reads | The Disk Reads chart shows the rate at which data is being read off each disk. |
| Service Time | The Service Time chart shows the sustained service time for all disks on the machine you are diagnosing. If the sustained service time of any of your disks exceeds 50 milliseconds, move your data onto the under-utilized disks. |
| Disk Writes | The Disk Writes chart shows the rate at which data is being written to each disk. |
| Queue Length | The Queue Length chart shows the average number of write operations waiting to be completed for each disk. |
| Wait Time | The Wait Time chart shows the amount of time that the queue for each disk is not empty. The time is expressed as a percentage of total time. |
| Busy | The Busy chart shows the amount of time each disk spends processing its transactions. The time is expressed as a percentage of total time. |
To view the Disk page as a table
Right-click the Disk page and select View as Grid.
Memory Page
The Memory page contains several charts.
To open the network page
- Select the Spotlight on Unix connection in the Spotlight Browser.
-
Click Activity Summary | Memory.
Charts on the Memory page
Notes:
- Every chart has a legend (list of symbols) to its right that describes the various series (line graphs) on the chart.
- Click an item in the legend to highlight its series (line) in the chart. Click a second time to return the series to its normal appearance.
- Move the mouse pointer over an item in the legend to view the current value for that series within the chart.
| Chart | Description |
|---|---|
| Physical | The Physical Memory chart shows the total physical memory (RAM) on the Unix host, and the amount of physical memory that is currently free. |
| Virtual | The Virtual Memory chart shows the total amount of memory in use on the Unix host. This includes physical memory plus space in the paging files. A steady increase in virtual memory usage can indicate that a process on the system has a memory leak. |
| Paging |
The Paging chart shows the rate at which pages are being swapped in and out of memory. The chart displays three data series:
A sustained high rate of paging can cause problems with overall system degradation due to disk thrashing and CPU load. Note: Scan rate is not available for Linux. |
| Cache | The Cache chart shows the percentage of recent file requests (read and write) that are satisfied by the memory cache, and that do not require a request to the paging areas on disk. |
CPU Page
The CPU page contains several charts.
To open the network page
- Select the Spotlight on Unix connection in the Spotlight Browser.
-
Click Activity Summary | CPU.
Charts on the CPU page
Notes:
- Every chart has a legend (list of symbols) to its right that describes the various series (line graphs) on the chart.
- Click an item in the legend to highlight its series (line) in the chart. Click a second time to return the series to its normal appearance.
- Move the mouse pointer over an item in the legend to view the current value for that series within the chart.
| Chart | Description |
|---|---|
| Total CPU Usage | The total CPU utilization for all processors on the Unix host. |
| CPU Usage by Processor | The CPU utilization for each processor on the Unix host. Each processor is represented by a single line on the chart, and by an item in the legend at the top right of the chart. |
| Run Queues | The number of threads (program execution units) that are waiting to run on the Unix host. |
| Context Switching |
The rate at which the Unix host has been processing context switches. A context switch occurs when a processor switches from one thread to another. Context switches occur when a running thread voluntarily relinquishes the processor, is pre-empted by a higher priority ready thread, or switches between user-mode and privileged (kernel) mode to invoke a system service. |