Documentation forSQL Sentry

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 option Description 
Sort Ascending Sorts the selected column by ascending order.
Sort Descending Sorts the selected column by descending order.
Clear Sorting Clears the sorting options for the selected column.
Clear All Sorting Clears all sorting options for the selected pane.
Group By This Column Groups the displayed information by the selected column.
Show Group by box Shows the group by box for the selected pane.
Hide This Column Hides the selected column.
Column Chooser Opens the Column Chooser. The Column Chooser provides additional columns to sort information.
Best Fit Expands the information for the selected column.
Best Fit (all columns) Expands the information for all columns.
Filter Editor Opens the filter editor.
Show Find Panel Opens the Find Panel. Use this panel to locate specific text within your selected pane.
Show Auto Filter Row Opens the Auto Filter Row. Use the Auto Filter Row to add specific filters within your selected pane.

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. SQL Sentry Azure Synapse SQL Pool Jump To

Jump To Options

Jump to Option Description
Jump To > Calendar Opens the Event Calendar view for the selected query.
Jump To > DMS Dashboard Opens the DMS Dashboard with metrics for the selected query.
Jump To > Distributed Queries  Opens the Distributed Queries tab with metrics for the selected query. 

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.

SQL Sentry Azure Synapse SQL Pool Copying Queries