Chat now with support
Chat with Support

Spotlight on SAP ASE 2.12 - User Guide

Spotlight on SAP ASE
Background Information Desktop Features Connect to SAP ASE Spotlight® on SAP ASE Drilldowns Spotlight® on SAP ASE Alarms Glossary
Spotlight Basics
Spotlight Connections Monitor Spotlight Connections Alarms Charts, Grids And Home Page Components View | Options Troubleshooting
Spotlight History Spotlight on Windows
Connect to Windows Systems Background Information Home Page Alarms Drilldowns View | Options Troubleshooting
Spotlight on Unix About us Third-party contributions Copyright

Activity Page

The Activity page contains several charts.

To open the Activity page

  1. Select the Spotlight on Unix connection in the Spotlight Browser.
  2. 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.

Operating System Unit of Measure
Sun Solaris Kilobytes per second
HP-UX Pages per second
IBM AIX Pages per second
Linux Kilobytes per second. Old versions of the kernel may measure in blocks per second. Refer to your Linux documentation.
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.

 

Related Topics

Disk Page

The Disk page contains several charts.

To open the Disk page

  1. Select the Spotlight on Unix connection in the Spotlight Browser.
  2. 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.

 

Related Topics

Memory Page

The Memory page contains several charts.

To open the network page

  1. Select the Spotlight on Unix connection in the Spotlight Browser.
  2. 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:

  • Page In - The rate at which read requests are made to the swap device.
  • Page Out - The rate at which write requests are made to the swap device.
  • Scan rate - The rate at which the memory manager scans for a free page in swap. If this rate is rising, it indicates that system memory is under pressure.

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.

 

Related Topics

CPU Page

The CPU page contains several charts.

To open the network page

  1. Select the Spotlight on Unix connection in the Spotlight Browser.
  2. 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.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating