Azure Synapse Monitoring
Data movement dashboard
Data movement is normal, but there are times where heavy data movement can be an indication of poorly designed queries, or incorrectly distributed tables.
With SQL Sentry you can identify data movement activity quickly and easily. Zoom in to pinpoint periods of activity, navigate to a relevant time period, and easily toggle between other diagnostic and optimization features.
Distributed queries
The idea of a query changes when working with massively parallel systems, as every query needs to be broken down to smaller pieces, and then run against the individual "compute" resources on the system.
With SQL Sentry you can view details of each massively parallel processing (MPP) query. Filter, sort, and group historical information, including query step details.
Our collection of that activity parallels our standard SQL Server query collection theme and display, allowing Performance Advisor to show all historical information in a method that allows for filtering, sorting, grouping, and other historical analysis. We also provide the distributed query step details so that this information can be reviewed along with the primary query request information.
Loads, backups, and restores
For Azure Synapse we are tracking loads processes from SSIS packages so load performance can be tracked over time, providing a display like the distributed query collection.
With SQL Sentry you can view information about both in-process and historical events through the Loads, Backups, and Restores grid.
Intelligent alerting
We have provided a collection of health alerts that can be viewed by any period of time, and most importantly, can be used to generate alerts so that personnel can be immediately notified of any appliance health issues.
Event calendar
See activities in a calendar format so you can quickly identify potential resource constraint problems in massively parallel processing (MPP) systems.
Concurrency is an important aspect of performance, and with the calendar, the user is able to see all activity that is occurring at a given point in time in a graphical format that allows for quick diagnosis of potential resource constraint issues.
What is Azure Synapse?
Azure Synapse is a limitless analytics service bringing together data integration, enterprise data warehousing, and big data analytics.
What can you monitor for Azure Synapse in SQL Sentry?
SQL Sentry gives you detailed visibility into the queries, loads, backups, and restores of all your data. With the event calendar and intelligent movement dashboard, you always know what factors are impacting workload.
If you’re not monitoring Azure Synapse SQL Pools across your Microsoft data platform, then you’re not seeing the whole data performance picture.
SQL Sentry helps you get more value from your cloud-based data warehouse investment.
Why is it important to monitor Azure Synapse?
Ensuring optimal performance of your Azure Synapse SQL Pools means you can deliver accurate, business-critical information to your end users. SQL Sentry gives your data team logically presented, actionable metrics to view the entire data warehouse environment and quickly identify bottlenecks causing potential delays.
SQL Sentry comes with some of the industry’s lowest overhead, so as you grow, you’ll increase efficiency by minimizing additional overhead and costs.
Don’t get blindsided by performance issues across your data warehouse: Get SQL Sentry to accelerate delivery of your business-critical data.
How is MPP data movement shown in SQL Sentry?
The SQL Sentry Data Movement Dashboard is designed to allow the user to quickly identify data movement activity and zoom in to pinpoint time periods where activity was the highest. Additionally, it highlights when you have unbalanced activity across compute nodes and associated distributions.
- What is Azure Synapse?
- What can you monitor for Azure Synapse in SQL Sentry?
- Why is it important to monitor Azure Synapse?
- How is MPP data movement shown in SQL Sentry?
What is Azure Synapse?
Azure Synapse is a limitless analytics service bringing together data integration, enterprise data warehousing, and big data analytics.
Get started with Azure Synapse monitoring
SolarWinds SQL Sentry
Fast root cause analysis
Visibility across the data estate
Deep, actionable performance metrics with easy deep-dive capabilities
