Azure Synapse Analytics

This integration can be enabled via the Connect an Azure Account page.

This integration has 9 metrics.

List of Alerts

List of Dashboards

Azure Synapse Analytics

The dashboard provides information on the Azure Synapse Analytics integration.

List of Metrics

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