Loads/Backups/Restores

Loads/Backups/Restores tab

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

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

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

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

SentryOne Hide Group by box

SentryOne 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.SentryOne Sort Ascending context menuSentryOne Sort Ascending applied
Sort DescendingSorts the selected column by descending order.SentryOne Sort Descending context menuSentryOne Sort Descending applied
Clear SortingClears the sorting options for the selected column.SentryOne Clear Sorting context menuSentryOne Clear Sorting applied
Clear All SortingClears all sorting options for the selected pane.SentryOne Clear All Sorting context menuSentryOne Clear All Sorting applied
Group By This ColumnGroups the displayed information by the selected column.SentryOne Group By This Column context menuSentryOne Group By This Column applied
Show Group by boxShows the group by box for the selected pane.SentryOne Show Group By Box context menuSentryOne Show Group By Box applied
Hide This ColumnHides the selected column.SentryOne Hide This Column context menuSentryOne Hide This Column applied
Column ChooserOpens the Column Chooser. The Column Chooser provides additional columns to sort information.SentryOne Column Chooser context menuSentryOne Column Chooser
Best FitExpands the information for the selected column.SentryOne Best Fit context menuSentryOne Best Fit applied
Best Fit (all columns)Expands the information for all columns.SentryOne Best Fit (all columns) context menuSentryOne Best Fit (all columns) applied
Filter EditorOpens the filter editor.SentryOne Filter Editor context menuSentryOne Filter Editor
Show Find PanelOpens the Find Panel. Use this panel to locate specific text within your selected pane.SentryOne Show Find Panel context menuSentryOne 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.SentryOne Show Auto Filter Row context menuSentryOne 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. SentryOne select query
  2. Select Jump To > desired option from the context menu to open the desired option. SentryOne Jump To

Jump To Options

Jump to OptionDescriptionImage
Jump To > CalendarOpens the Event Calendar view for the selected query.SentryOne Jump To > Calendar
Jump To > DMS DashboardOpens the DMS Dashboard with metrics for the selected query.SentryOne Jump To > DMS Dashboard
Jump To > Distributed Queries Opens the Distributed Queries tab with metrics for the selected query. SentryOne 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.

SentryOne Copying Queries