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 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.

    In 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 only the most recent collection interval.
Related tasks
Executing SQL Statements