Chat now with support
Chat with Support

Spotlight on SAP ASE 2.11 - 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

Memory Panel

The Memory panel displays information about the following:

 

Data Cache Writes/Reads

This section of the Home Page displays data for the number of data cache physical writes and data cache physical reads per second.

 

Procedure Cache Reads

This section of the Home Page displays the rate at which stored procedures are read from disk.

As users execute stored procedures, Adaptive Server looks in the procedure cache for a query plan to use. If a query plan is available, execution begins.

If no plan is in memory, or if all copies are in use, the query tree for the procedure is read from disk.

 

Disk Storage Panel

The Disk Storage panel has two main sections:

I/O Busy

In addition to showing ASE performance of I/O related tasks (as a percentage), the I/O Busy section also displays the number of I/O disk devices.

Databases

In addition to displaying the number of databases, the Databases section shows:

  • Size of the fullest database being monitored

  • Percentage of space used by the fullest database, along with a container representing this same data

  • Size of the fullest transaction log being monitored

  • Percentage of space used by the fullest transaction log, along with a container representing this same data

  • Size of the fullest Temp DB being monitored

  • Percentage of space used by the fullest temp DB, along with a container representing this same data

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating