See the SQL statement and query plan for an Adaptive Server user process.
-
In the Perspective Resources view, right-click the server you want to monitor and select Monitor.
-
In the left pane, select Processes.
-
Click either the All Processes tab or the Blocked Processes tab.
-
(Optional for Adaptive Server 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.
-
To select a process, click a row in the table.
-
At the bottom of the window, click the SQL tab.
The tab shows the SQL query and query plan for this process.