azureazure-sql-databaseazureportalazure-data-sync

How to monitor the Azure data sync process in Azure Portal


I am using Azure Data Sync to load data from one database to another. I want to monitor the performance and the resource consumption of the data sync between the two databases. I know that Azure portal has some monitoring tools but how can I use it to check the data sync process in particular? Any suggestions please.


Solution

  • The best you can do is to use Log Analytics to monitor Azure Data Sync as explained here. It will provide you a dashboard to monitor Azure SQL Data Sync as shown below.

    enter image description here

    Log Analytics will also provide you e-mail notifications as shown below:

    enter image description here

    For detailed information about how to configure this solution, you can visit this documentation.

    In addition you can have metrics about CPU usage, Log IO, storage spaces of your Azure SQL Databases if you monitor it with Azure Monitor (the new name of Azure Log Analytics). For more information visit this documentation.

    enter image description here

    enter image description here