Tchater maintenant avec le support
Tchattez avec un ingénieur du support

Spotlight on SAP ASE 2.11 - Release Notes

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

Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation