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

User Activity Drilldown SQL Activity Page

The SQL Activity Page consists of a grid and a text box below the grid.

The SQL Activity grid is displayed when you select the SQL Activity Page on the Process Activity tab of the User Activity drilldown.

This grid shows the performance history of SQL statements that have run for accounts that are currently logged in.

Note: Only SQL Text is available for pre-12.5.03 servers.

The following columns are available:

Column

Definition

User Name

Name of User who executed the SQL statement

DB Name

Database name associated with the SQL statement

Start Time

Time the SQL statement started

Run Time (sec)

Duration of SQL statement run time

Log Reads

Number of logical reads performed by the SQL statement

Phys Reads

Number of physical reads performed by the SQL statement

Pgs Mod

Number of pages modified by the SQL statement

Mem Use (KB)

Amount of memory used by the SQL statement (in Kilobytes)

Wait Time (ms)

Amount of time the process waited for Adaptive Server resources to become available

SQL Text

First line of SQL statement text

Note: Selecting a line on this grid displays the full text of the selected SQL Statement in the SQL Formatter text box on the bottom left.

If the current SQL statement indicates the execution of a stored procedure, the contents of the procedure will display in the SQL Formatter text box on the bottom right. 

Note: SQL statements will not be shown for users who have logged off Adaptive Server before Spotlight connected. In addition, SQL statements for system processes will not be shown.

To launch SQL Tuning from the SQL Activity Page

  1. Select a SQL Text line on the SQL Activity grid.

  2. Right-click anywhere on the SQL Activity grid, and then select "Launch SQL Tuning..." from the menu displayed.

    Note: When you launch SQL Tuning, it connects to the database you're currently in, and the SQL Statement is loaded. You can then use SQL Tuning features.

 

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione