Chatta subito con l'assistenza
Chat con il supporto

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

Unit of Work sub drilldown for the Current SQL tab

The Unit of Work sub drilldown provides additional information for the SQL statement that is currently executing for the unit of work. This is the statement that was selected in the Current SQL tab of the Top SQL drilldown. The sub drilldown contains three panes:

  • Statement pane—This pane shows the SQL statement that is currently executing for the unit of work. If you want to tune the statement, you can open a tuning session in SQL Optimizer for DB2 by clicking the SQL Tuning icon.

  • UOW Details pane—This pane shows details for the SQL statement that is currently executing for the unit of work. The details include statement start and stop times, number of concurrent agents, and number of blocking cursors.

  • UOW Activity pane—This pane shows activity counts for the SQL statement that is currently executing for the unit of work. The counts provide a measure of how the current unit of work is impacting database resources.

From this sub drilldown, you can also open a tuning session on the statement.

 

Related Topics

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione