Distributed Queries

Applies to: DW Sentry and APS Sentry

Distributed Queries tab

View details of each Massively Parallel Processing (MPP) query. Filter, sort, and group historical information, including query step details. 

DW Sentry Distributed Queries tab

Active Requests Grid

DW Sentry Distributed Queries Active Requests grid

The Active Requests grid displays active queries that are running at the time of collection in your Azure SQL Data Warehouse environment. Each column header in the Active Requests grid provides you with detailed data about your environment. See the following table for descriptions about these data metrics:

Default Column headerColumn Description
CommandDisplays the Query command text for the active request.
Status Displays the status of the active request (Completed, Active, Failed).
Login Displays the login of the active request's user.
Login timeDisplays the corresponding login time for the active request.
Submit timeDisplays the submittal time for the active request.
Queue DurationDisplays the amount of time the active request was in the query queue.
Compile DurationDisplays the amount of time taken for the active request to be compiled.
Execution DurationDisplays the time the active request spent actively using processor resources.
Total Elapsed timeDisplays the Total Elapsed time that the active request was running at the time of data collection.
End timeDisplays the end time of the active request.
ApplicationDisplays the Application where the active request is running.
LabelDisplays any label(s) associated with the active request.
Resource ClassDisplays the resource class for the active request. 
Client IDDisplays the Client ID of the active request.
SQL SpidDisplays the SQL Server process ID for the active request.
Transactional


ErrorDisplays any associated error information for the active request.
Request IDDisplays the Request ID of the active request.
Session IDDisplays the Session ID of the active request.

Add additional columns to the Active Requests grid by right clicking the column header and then selecting Column Chooser to open the Column Chooser.

DW Sentry Active Requests Column Chooser

See the following table for additional columns that can be added in  the Active Requests grid:

Optional ColumnColumn Description
End Compile timeDisplays the time when the active request finished compiling.
IDDisplays the ID number of the active request.
Start TimeDisplays the time when the active request began. 
Completed Requests Grid

The Completed Requests grid displays the completed queries in your environment. Expand the Completed Requests tab by selecting the arrow icon at the bottom of the grid.

DW Sentry Expand Completed Requests grid
Select the arrow to expand 
DW Sentry Completed Requests grid expanded
Completed Requests Expanded

Each column header in the Completed Requests grid provides you with detailed data about your environment. See the following table for descriptions about these data metrics:

Default Column headerColumn Description
CommandDisplays the Query command text of the completed request.
StatusDisplays the status of the completed request ( Completed, Active, Failed).
LoginDisplays the login of the completed request's user.
Login timeDisplays the corresponding login time for the completed request.
Submit timeDisplays the submit time for the complete request.
Queue DurationDisplays the amount of time the completed request was in the query queue.
Compile DurationDisplays the amount of time taken for the completed request to be compiled.
Execution DurationDisplays the time the completed request spent actively using processor resources.
Total Elapsed timeDisplays the total time the completed request was running.
End timeDisplays the time the completed request ended.
ApplicationsDisplays the application(s) where the completed request was running.
LabelDisplays any label(s) associated with the completed request.
Resource classDisplays the resource class of the completed request.
Client IDDisplays the Client ID of the completed request.
SQL SpidDisplays the SQL Server process ID for the completed request.
Transactional


ErrorDisplays any error(s) associated with the completed request.
Error IDDisplays the Error ID associated with the completed request.
Request IDDisplays the Request ID of the completed request.
Session ID Displays the Session ID of the completed request.

Add additional columns to the Completed Requests grid by right clicking a column header and then selecting Column Chooser to open the Column Chooser.

DW Sentry Completed Requests Column ChooserSee the following table for additional columns that can be added in the Completed Requests grid:

Optional ColumnColumn Description
End Compile timeDisplays the time when the completed request finished compiling.
IDDisplays the completed request ID number.
Start TimeDisplays the time when the completed request began.
Request Steps Grid

The Request Steps grid displays the request steps of the selected completed query. Select a query in the Completed Requests grid to display that query's steps.

DW Sentry Request Steps grid 

Note:  The Request Steps grid has the Group by box hidden by default. Unhide the Group by box by right clicking the top of the grid and then selecting Show Group by box.
DW Sentry Show Group by box

Each column header in the Request Steps grid provides you with detailed data about your environment. See the following table for descriptions about these data metrics:

Default Column headerColumn Description
Step IndexDisplays the step index number of the selected query.
CommandDisplays the Query command text of the selected query.
StatusDisplays the status of the selected query (Completed, Active, Failed).
Total Elapsed timeDisplays the total time the selected query was running.
Operation typeDisplays the operation category associated with the selected query.
Distribution typeDisplays the distribution category associated with the selected query.
Location typeDisplays the location category of the selected query.
Start timeDisplays the time when the selected query began.
End timeDisplays the time when the selected query ended.
Error IDDisplays any Error ID associated with the selected query.
Row countDisplays the number of rows processed by the selected query.
Request ID Displays the Request ID of the selected query.

Add additional columns to the Request Steps grid by right clicking the column header and then selecting Column Chooser to open the Column Chooser.

DW Sentry Request Steps Column ChooserSee the following table for additional columns that can be added in the Request Steps grid:

Optional columnColumn Description
Appliance


CommandDisplays the Query command text for the selected query.
End timeDisplays the time when the selected query ended.
IDDisplays the ID number associated with the selected query.
Start timeDisplays the time when the selected query began.
Step IndexDisplays the Step index associated with the selected query.
Time Zone Factor Minutes


Utc offset


SQL Requests Grid

The SQL Requests grid displays SQL request metrics for the selected completed query. Select a query in the Completed Requests grid to display that query's SQL Requests.

Note:  The SQL Requests grid has the Group by box hidden by default. Unhide the Group by box by right clicking the top of the grid and then selecting Show Group by box.
DW Sentry Show Group by box

Each column header in the SQL Requests grid provides you with detailed data about your environment. See the following table for descriptions about these data metrics:

Default Column headerColumn Description
PlanOpen the Plan diagram for the selected query.
Step indexDisplays the SQL Step index associated with the selected query.
Remote Node IDDisplays the Remote Node ID of the selected query.
Distribution IDDisplays the Distribution ID of the selected query. 
CommandDisplays the Query command text of the selected query.
StatusDisplays the status of the selected query (Completed, Active, Failed).
Total Elapsed timeDisplays the total time the selected query was running.
Start timeDisplays the time when the selected query began.
End timeDisplays the time when the selected query ended.
Error IDDisplays the Error ID associated with the selected query.
Row CountDisplays the number of rows processed by the selected query.
SpidDisplays the Service Profile Identifier associated with the selected query.

Add additional columns to the SQL Requests grid by right clicking the column header and then selecting Column Chooser to open the Column Chooser.

DW Sentry SQL Requests Column ChooserSee the following table for additional columns that can be added in the Request Steps grid:

Optional ColumnColumn Description
Appliance


Appliance ID


IDDisplays the ID of the selected query.
Request IDDisplays the Request ID of the selected query.
Time Zone Factor Minutes


Utc offset


Additional Information

Grouping Queries

Group the queries in any grid by dragging a header into the Group by box. For more information about grouping queries, see the Data Grids topic.

Sorting Queries by columns

Sort rows by ascending or descending order in any grid by selecting the arrow icon on the desired column header. For more information about sorting queries in data grids, see the Data Grids topic.

Filtering Queries

Add a filter to any desired row by selecting the filter button. For more information about filtering queries, see the Data grids topic.

Copying Queries

Copy query cells, rows, or all data by selecting and right clicking a query, and then selecting the desired option from the context menu. For more information about copying queries in a data grid, see the Data Grids topic. 

Additional Context menu options

Access the following additional context menu options by right-clicking a column header in any grid:

Context menu optionDescription Context menu ImageOption applied
Sort AscendingSorts the selected column by ascending order.DW Sentry Sort Ascending context menuDW Sentry Sort Ascending applied
Sort DescendingSorts the selected column by descending order.DW Sentry Sort Descending context menuDW Sentry Sort Descending applied
Clear SortingClears the sorting options for the selected column.DW Sentry Clear Sorting context menuDW Sentry Clear Sorting applied
Clear All SortingClears all sorting options for the selected grid.DW Sentry Clear All Sorting context menuDW Sentry Clear All Sorting applied
Group by this columnGroups the displayed information by the selected column.DW Sentry Group By This Column context menuDW Sentry Group By This Column applied
Show Group by boxShows the group by box for the selected grid.DW Sentry Show Group by box context menuDW Sentry Show Group by box applied
Hide This ColumnHides the selected column.DW Sentry Hide This Column context menuDW Sentry Hide This Column applied
Column ChooserOpens the Column Chooser. The Column Chooser provides additional columns to sort information.DW Sentry Column Chooser context menuDW Sentry Column Chooser
Best FitExpands the information for the selected column.DW Sentry Best Fit context menuDW Sentry Best Fit applied
Best Fit (all columns)Expands the information for all columns.DW Sentry Best Fit (all columns) context menuDW Sentry Best Fit (all columns) applied
Filter EditorOpens the filter editor.DW Sentry Filter Editor context menuDW Sentry Filter Editor
Show Find PanelOpens the Find Panel. Use this panel to locate specific text within your selected grid.DW Sentry Show Find Panel context menuDW Sentry Show Find Panel applied
Show Auto Filter RowOpens the Auto Filter Row. Use the Auto Filter Row to add specific filters within your selected grid.DW Sentry Show Auto Filter Row context menuDW Sentry Show Auto Filter Row applied

Using Jump to 

Jump to takes you to any of the following four options when selecting any query on the Distributed Queries tab:

  • Calendar
  • DMS Dashboard
  • Loads/Backups/Restores
  • Runtime Stats

To use the Jump to context menu option complete the following steps:

  1. Select a query in any grid, and then right click the query to open the context menu.
    DW Sentry select a query
  2. Select Jump to > desired option from the context menu to open the desired option.
    DW Sentry Jump To

Jump to options

Jump to OptionDescriptionImage
Jump to > CalendarOpens the Event Calendar view for the selected query.DW Sentry Jump To > Calendar
Jump to > DMS DashboardOpens the Data Movement Dashboard for the selected query.DW Sentry Jump To > DMS Dashboard
Jump to > Loads/Backups/
Restores
Opens the Loads/Backups/Restores tab for the selected query.DW Sentry Jump To > Loads/Backups/Restores
Jump to > Runtime statsOpens a Runtime Statistics graph for the selected query. The Runtime Statistics graph displays in history view by default. 
DW Sentry Jump To > Runtime stats
History View
DW Sentry Jump To > Runtime stats
Aggregate View