Loads/Backups/Restores

Loads/Backups/Restores tab

View information about both in-process and historical events through the Loads/Backups/Restores tab.

Loads/Backups Restores tab

Loader Backup Runs Grid

The Loader Backup Runs grid displays data loads entering into the Azure Synapse target, as well as backups and restores of the Azure Synapse target itself. Organize the displayed information to quickly correlate performance activity in your Azure Synapse environment.

Loader Backup Runs grid

Loader Backup Run Details Grid

The Loader Backup Run Details grid displays detailed information about data loads entering into the Azure Synapse target, as well as backups and restores of the Azure Synapse target itself. Organize the displayed information to quickly correlate performance activity in your Azure Synapse environment. 

Loader Backup Run Details Grid

Grouping Queries

For information about grouping queries in the Loader Backup Runs grid, see the Data Grids topic. 

Note:  Hide the Group by box by right-clicking the Group by area, and then selecting Hide Group by box from the context menu. Open the Group By Box by right-clicking a header, and then selecting Show Group By Box from the context menu.

Hide Group by box

Show Group By Box

Sorting Queries by Columns

For information about sorting queries by column, see the Data Grids topic. 

Filtering Columns

For information about filtering columns, 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.Sort Ascending context menuDW Sentry Sort Ascending applied
Sort DescendingSorts the selected column by descending order.Sort Descending context menuSort Descending applied
Clear SortingClears the sorting options for the selected column.Clear Sorting context menuClear Sorting applied
Clear All SortingClears all sorting options for the selected pane.Clear All Sorting context menuClear All Sorting applied
Group By This ColumnGroups the displayed information by the selected column.Group By This Column context menuGroup By This Column applied
Show Group by boxShows the group by box for the selected pane.Show Group By Box context menuShow Group By Box applied
Hide This ColumnHides the selected column.Hide This Column context menuHide This Column applied
Column ChooserOpens the Column Chooser. The Column Chooser provides additional columns to sort information.Column Chooser context menuDW Sentry Column Chooser
Best FitExpands the information for the selected column.Best Fit context menuBest Fit applied
Best Fit (all columns)Expands the information for all columns.Best Fit (all columns) context menuBest Fit (all columns) applied
Filter EditorOpens the filter editor.Filter Editor context menuDW Sentry Filter Editor
Show Find PanelOpens the Find Panel. Use this panel to locate specific text within your selected pane.Show Find Panel context menuShow Find Panel applied
Show Auto Filter RowOpens the Auto Filter Row. Use the Auto Filter Row to add specific filters within your selected pane.Show Auto Filter Row context menuShow Auto Filter Row applied

Using Jump to

Jump To takes you to any of the following options when selecting any query on the Loads/Backups/Restores tab:

  • Calendar
  • DMS Dashboard
  • Distributed Queries 

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. select 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 DMS Dashboard with metrics for the selected query.DW Sentry Jump To > DMS Dashboard
Jump To > Distributed Queries Opens the Distributed Queries tab with metrics for the selected query. DW Sentry Jump To > Distributed Queries

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.

DW Sentry Copying Queries