Loads/Backups/Restores

Applies to: DW Sentry and APS Sentry

Loads/Backups/Restores tab

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

DW Sentry Loads/Backups Restores tab

Loader Backup Runs Grid

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

DW Sentry Loader Backup Runs grid

Loader Backup Run Details Grid

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

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

DW Sentry Hide Group by box

DW Sentry 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.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 pane.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 pane.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 pane.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 pane.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 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.
    DW Sentry 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