Monitoring active queries - Parallel Data Warehouse
This article shows how to use the Admin Console and the SQL Server PDW system views to monitor active queries. See Monitor the Appliance by Using the Admin Console and System Views for information on these tools.
Regardless of the method used to monitor active queries, the login must have the permissions described in “Use All of the Admin Console” in Grant Permissions to Use the Admin Console.
Monitor Active Queries
Both the Admin Console and the SQL Server PDW system views can be used to monitor active queries. Follow the instructions below.
To monitor active queries by using the Admin Console
Log on to the Admin Console. See Monitor the Appliance by Using the Admin Console for instructions.
On the top menu, click Queries. You will see a table with basic information about the most recent queries on the appliance, including the login who submitted the query, the start and end times for the query, and the current status of the query.
To see the query command, hover the mouse pointer over the query ID in the left column for that row.
To see more detailed information for a particular query, click the query ID. You will see information including the full query and the query plan, with status information for each step in the query execution. If any errors were returned, you can also see detailed information on the errors.
To monitor active queries by using the system views
The primary system view used to monitor queries is sys.dm_pdw_exec_requests. Use this system view to find the
request_id for an active or recent query, based on the query text.
For example, the following query finds the
request_id and the current
status for any query that selects all columns from the
SELECT request_id, command, status FROM sys.dm_pdw_exec_requests WHERE command LIKE ‘%SELECT * FROM db1..memberAddresses%’;
request_id has been identified for a query, use the other information in the
dm_pdw_exec_requests table to find out about the processing of the query, or use sys.dm_pdw_request_steps to view the status of the individual query steps for the query execution.