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

Nitya V 20 Reputation points
2024-01-29T07:35:04.4066667+00:00

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

Azure SQL Database
{count} votes

2 answers

Sort by: Most helpful
  1. ShaktiSingh-MSFT 12,231 Reputation points Microsoft Employee
    2024-01-29T08:39:37.5566667+00:00

    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

    0 comments No comments

  2. Sedat SALMAN 12,200 Reputation points
    2024-01-29T08:47:08.7766667+00:00

    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/

    0 comments No comments