Azure Synapse Analytics
This integration can be enabled via the Connect an Azure Account page.
This integration has 9 metrics.
List of Alerts
| Alert | Description | Format |
|---|---|---|
| [Azure Synapse Analytics] High Login Error Rate | Too many unsuccessful login attempts to the built-in SQL. | Prometheus |
| [Azure Synapse Analytics] Requests Ended High Error Rate | Too many failed SQL requests. | Prometheus |
| [Azure Synapse Analytics] Activities Ended High Error Rate | Too many activities returned failed results. | Prometheus |
| [Azure Synapse Analytics] Failed Link Table High Error Rate | Too many failed link table events. | Prometheus |
List of Dashboards
Azure Synapse Analytics
The dashboard provides information on the Azure Synapse Analytics integration.
List of Metrics
| Metric name |
|---|
| azure_synapse_workspaces_builtin_sql_pool_data_processed_bytes_sum |
| azure_synapse_workspaces_builtin_sql_pool_login_attempts |
| azure_synapse_workspaces_builtin_sql_pool_requests_ended |
| azure_synapse_workspaces_integration_activity_runs_ended_count |
| azure_synapse_workspaces_integration_link_connection_events_sum |
| azure_synapse_workspaces_integration_link_processed_changed_rows_sum |
| azure_synapse_workspaces_integration_link_processed_data_volume_sum |
| azure_synapse_workspaces_integration_link_processing_latency_in_seconds_avg |
| azure_synapse_workspaces_integration_link_table_events_sum |
Monitoring and Troubleshooting Azure Synapse Analytics
This document describes important metrics and queries that you can use to monitor and troubleshoot Azure Synapse Analytics.
Built-in SQL Pool
Login attempts
Use the following query to check the number of unsuccessful login attempts in the SQL built-in pool in the last 10 minutes:
sum (sum_over_time(azure_synapse_workspaces_builtin_sql_pool_login_attempts{result="Failed"}[10m])) by (cloud_provider_account_id,cloud_provider_region_name,resource_group,cloud_provider_resource_name,result)
A return value other than 0 indicates that some service is trying to access to SQL with incorrect credentials.
Data processed
Use the following query to get the number of bytes processed by SQL built-in pool:
azure_synapse_workspaces_builtin_sql_pool_data_processed_bytes_sum
Requests ended with error
Use the following query to check the number of error requests in the SQL built-in pool:
sum (sum_over_time(azure_synapse_workspaces_builtin_sql_pool_requests_ended{result="Failed"}[10m])) by (cloud_provider_account_id,cloud_provider_region_name,resource_group,cloud_provider_resource_name,result)
Synapse activities
Activities runs ended
Use the following query to get the number of activities in failed result:
azure_synapse_workspaces_integration_activity_runs_ended_count{result="Failed"}
Synapse Link
Link table events
Use the following query to get the number of link table events:
sum(azure_synapse_workspaces_integration_link_table_events_sum) by (cloud_provider_region_name, resource_group, cloud_provider_resource_name, linkconnectionname, eventtype, tablename)
Link connection events
Use the following query to get the number of link connection events:
sum(azure_synapse_workspaces_integration_link_connection_events_sum) by (cloud_provider_region_name, resource_group, cloud_provider_resource_name, linkconnectionname, eventtype)
Link processed data volume
Use the following query to get the link bytes processed:
azure_synapse_workspaces_integration_link_processed_data_volume_sum
Link changed rows
Use the following query to get the number of rows changed:
azure_synapse_workspaces_integration_link_processed_changed_rows_sum
Link latency
Use the following query to get the link latency in seconds:
azure_synapse_workspaces_integration_link_processing_latency_in_seconds_avg
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.