Displaying the SQL Query Associated with a Process

See the SQL statement and query plan for an SAP ASE user process.

1. In the Perspective Resources view, select the server to monitor, click the drop-down arrow, and select Monitor.
2. In the left pane, select Processes.
3. Click either the All Processes tab or the Blocked Processes tab.
4. (Optional for cluster configurations) Click Select User Processes by. Choose All Instances to depict information for the entire cluster, or select a specific instance to see information for only the selected instance of the cluster.
5. To select a process, click a row in the table.
6. At the bottom of the window, click the SQL tab.
   The tab shows the SQL query and query plan for this process.