SQL Data Sync -- How to set up alert for Data Sync group errors or failures

Question

How can we set up alert notifications for Data Sync failures,I couldnot find an option on Alert Monitoring

Answer 1

Hi
Nitya V •,

Welcome to Microsoft Q&A fourm.

As I understand, you want to set up alert for Azure SQL Data Sync.

Please refer to the blogpost here https://azure.microsoft.com/es-es/blog/monitoring-azure-sql-data-sync-using-oms-log-analytics/ where you can make use of

• PowerShell Runbook to feed Data Sync Log Data to OMS
• OMS Log Analytics alert for email notifications
• OMS view for monitoring

to set up your custom Data Sync OMS monitoring solution.

Hope this helps. Let us know if you have further queries.

Thanks

Answer 2

I offer you to follow the following links for more details the topic is not so well defined but you can track the possible problems and causes with this link

https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-troubleshoot?view=azuresql

and this article may help you to monitor Sync Event https://azure.microsoft.com/es-es/blog/monitoring-azure-sql-data-sync-using-oms-log-analytics/