Loads/Backups/Restores
Loads/Backups/Restores tab
View information about both in-process and historical events through the 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 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.
Grouping Queries
For information about grouping queries in the Loader Backup Runs grid, see the Data Grids topic.
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.
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:
- Select a query in any grid, and then right click the query to open the context menu.
- Select Jump To > desired option from the context menu to open the desired option.
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.
