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

User Activity General Drilldown SQL History sub page

SQL History sub-page

The SQL History sub-page consists of two radio buttons (SQL Text and SQL Performance), each of which displays a grid. The data displayed on these grids is based on the process selected in the User Activity grid.

SQL Text grid

This grid shows details of active SQL statements.

The following table defines the fields on this grid:

Field

Definition

Start Time

Time the SQL statement started

DB Name

Database name associated with the SQL statement

SQL Text 

First line of SQL statement text

 

SQL Performance grid

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

The SQL statements shown are for the process selected in the User Activity grid.

The following table defines the columns on this grid:

Field

Definition

Run Time (sec)

Duration of SQL statement run time

Log Reads

Number of logical reads

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

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. 

To launch SQL Tuning

  1. Select a SQL Text line from either the SQL Text grid or the SQL Performance grid.

  2. Right-click on the line you selected, 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.

Select Rating

I easily found the information I needed.

Select Rating