Monitoring SQL Queries

Display details about recently executed SQL queries.

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 SQL Activity.
   The SQL Activity screen appears. It lists queries executed during the current trend period, along with details including each query’s server process identifier (spid), the login account that executed the query, the kernel process identifier (KPID), batch identifier, and execution statistics.

   Note: In Adaptive Server cluster configurations, information in the Active SQLs table is grouped by cluster instances.
3. Select a SQL query from the Active SQLs in Batch table.
   The SQL statement appears at the bottom of the screen.

   Note: The SQL Activity screen displays SQL text for the most recent collection interval only.