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.
Related tasks
Displaying Wait Events for a Process
Identifying the Lead Blocker in a Chain
Identifying Resource-Intensive Processes
Identifying Blocked Processes and Blocking Processes
Terminating Blocking Processes
Related reference
Process Statistics and Details