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

Process Activity drilldown

Using the Process Activity drilldown

The Process Activity drilldown provides access to details of user connections, problem users, and processes running on an ASE.

To display the Process Activity drilldown

Click Users or press Ctrl + U.

Note: You can also select View | Go To | Users.

Data in the Process Activity drilldown

The Process Activity General drilldown consists of a Process Activity Detail page with three sub-pages:

 

CPU Summary drilldown

Using the CPU Summary drilldown

The CPU Summary drilldown provides access to information about the amount of time the ASE spends on server-related tasks and the number of engines configured.

To display the CPU Summary drilldown

Click Engines or press Ctrl + E.

Note: You can also select View | Go To | Engines.

Data in the CPU Summary drilldown

The CPU Summary drilldown displays a CPU grid and a CPU page with five sub-pages, each of which can be opened by clicking on its associated tab:

 

Database Summary drilldown

Using the Database Summary drilldown

The Database Summary drilldown provides access to information about:

  • Number of databases

  • Size of the fullest database, transaction log, and temp DB being monitored

  • Percentage of space being used by the fullest database, transaction log, and temp DB being monitored

To display the Database Summary drilldown

Click Databases or press Ctrl + A.

Note: You can also select View | Go To | Databases.

Data in the Database Summary drilldown

The Database Summary drilldown displays a Databases grid and a Database Detail page with seven sub-pages, each of which can be opened by clicking on its associated tab:

 

Device Summary drilldown

Using the Device Summary drilldown

The Device Summary drilldown provides access to information about:

  • Number of physical writes and reads per second completed by the ASE

  • Percent of time spent by the ASE on I/O related tasks

  • Number of disk devices

  • Number of physical reads per second by the data cache

  • Number of stored procedures read from the disk per second

To display the Device Summary drilldown

Click Devices or press Ctrl + D.

Note: You can also select View | Go To | Devices.

Data in the Device Summary drilldown

The Device Summary drilldown displays a Devices grid and a Devices page with three sub-pages, each of which can be opened by clicking on its associated tab:

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating