Spotlight on SAP ASE 2.12 - User Guide

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:

• User Activity

• SQL Activity

• Wait Events

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:

• CPU Summary

• Context Summary

• Checks Summary (available for pre-ASE 12.5.03 only)

• Wait Summary

  Note: Available for ASE 12.5.0.3 or later only.

• Detail

• Wait Detail

  Note: Available for ASE 12.5.0.3 or later only.

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:

• Summary

• Status

• Device Info

• Segment Info

• Transaction Log

• Open Objects Activity

• Open Objects I/O

• Top Objects

• Statistics Date

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:

• Summary

• Performance Detail

• General Detail