With the intelligent data movement dashboard and event calendar, you will always know exactly what is impacting your workload. Designed to give you visibility into your queries and jobs running to load, backup or restore your data, you will never worry about whether or not you are making the most of your Azure resources.
DW Sentry released in conjunction with General Availability of Azure SQL Data Warehouse, providing customers with the ability to get more value out of their cloud data warehouse investments.
The Data Movement dashboard highlights data movement activity, revealing key performance metrics within your Azure SQL Data Warehouse environment.
It also shows the correlation of that activity against the compute nodes and the associated distributions. Additional detail is provided from performance counters for the data movement service, and SQL Server CPU metrics.
The Distributed Queries view provides details about any live or historical requests, and the associated request steps.
Query collection thresholds can be set based on duration. The executed request, client, application, login, label, and resource class are provided along with pertinent performance metrics. When viewing a specific request, you can also view the related request step details including command, operation type, location type, and row count when appropriate.
The Loads, Backups, and Restores grid displays information for both in-process and historical events. Load events information is displayed on rows processed, rejected, and inserted. Application, table, and client as well as other pertinent performance metrics are collected
When available, load step details will be displayed including compute node specific details. Backup and restore events log similar information, including progress, operation type, database, application, and client information.
Built into DW Sentry are rich alerting features, allowing you to build alerts that are meaningful in your environments. Alerting areas covered via Advisory Conditions™ include health, distributed query performance thresholds, as well as load and backup performance.
Complete control over your notification settings means you will always know what is happening without being inundated by useless alerts.
The Event Calendar lets you visualize where specific activities may impact others while providing the ability to "jump to" run-time performance graphs where you can see specific query performance trends, and drill into the details of specific activities.
80 Per month
Subscription pricing is based on a 12-month term paid in advance with automatic renewal at the end of the term.
To get an evaluation of DW Sentry, or for more information, contact sales: 704-895-6241 | 855-775-7733 toll-free | firstname.lastname@example.org
For your convenience here are links to supported browsers:
Your browser could be incompatible with this website.
If you close this window and continue you may experience less than optimal behavior.