Monitoring and alerting setup on the Taks (Online data migration) of service Azure Database Migration Services ?

Question

Hi Team,

I have a Azure Database Migration Services in which i have created Azure Database Migration Project

under that we have Three Online data migration tasks which sync db from aws to azure. but when anyone of task is getting failed am not getting alert, as there is metric available for it.

Can anyone guide me how can i setup this monitoring and alerting here.

Regards

Kuldeep Singh

Answer 1

To set up monitoring and alerting for your Azure Database Migration Service (DMS) tasks, you can use Azure Monitor and Azure Alerts. Here's a step-by-step guide to help you configure this:

Step 1: Enable Diagnostic Settings

1. Navigate to your Azure DMS in the Azure portal.
2. Go to Diagnostic settings under the Monitoring section.
3. Click on Add diagnostic setting.
4. Select the metrics you want to monitor (e.g., Migration Task Failed).
5. Choose where to send the logs (Log Analytics, Storage Account, or Event Hub).
6. Click Save.

Step 2: Create a Log Analytics Workspace (if not already done)

1. Go to the Azure portal and search for Log Analytics workspaces.
2. Click on + Create.
3. Fill in the necessary details and create the workspace.

Step 3: Configure Alerts

1. Go to Azure Monitor in the Azure portal.
2. Select Alerts from the left-hand menu.
3. Click on + New alert rule.
4. In the Scope section, select your Azure DMS resource.
5. In the Condition section, click on Add condition.
   • Select a signal like Log Analytics if you are using logs.
     • Write a query to detect failed migration tasks. For example:

           kusto
           Copy code
           AzureDiagnostics
     

| where ResourceType == "AZURE_DMS" | where Status == "Failed" ```

  1. Set the alert logic (e.g., when the count is greater than 0).
  
  1. In the **Actions** section, select or create an action group (which can send emails, SMS, etc.).
  
  1. Configure the **Alert rule details** (name, description, severity).
  
  1. Click **Create alert rule**.
  

Step 4: Test Your Alerts

1. Simulate a failure in one of your migration tasks.
2. Check if the alert triggers and you receive the notifications as expected.

Additional Tips

• You can also use Azure Functions or Logic Apps to create more complex alerting mechanisms if needed.
• Regularly review the performance metrics and logs for proactive monitoring.

This setup should give you a good start in monitoring your Azure DMS tasks and receiving alerts when any task fails. If you need more specific guidance based on your scenario, feel free to ask!To set up monitoring and alerting for your Azure Database Migration Service (DMS) tasks, you can use Azure Monitor and Azure Alerts. Here's a step-by-step guide to help you configure this:

Step 1: Enable Diagnostic Settings

1. Navigate to your Azure DMS in the Azure portal.
2. Go to Diagnostic settings under the Monitoring section.
3. Click on Add diagnostic setting.
4. Select the metrics you want to monitor (e.g., Migration Task Failed).
5. Choose where to send the logs (Log Analytics, Storage Account, or Event Hub).
6. Click Save.

Step 2: Create a Log Analytics Workspace (if not already done)

1. Go to the Azure portal and search for Log Analytics workspaces.
2. Click on + Create.
3. Fill in the necessary details and create the workspace.

Step 3: Configure Alerts

1. Go to Azure Monitor in the Azure portal.
2. Select Alerts from the left-hand menu.
3. Click on + New alert rule.
4. In the Scope section, select your Azure DMS resource.
5. In the Condition section, click on Add condition.
   • Select a signal like Log Analytics if you are using logs.
     • Write a query to detect failed migration tasks. For example:

           kusto
           Copy code
           AzureDiagnostics
     

| where ResourceType == "AZURE_DMS" | where Status == "Failed" ```

  1. Set the alert logic (e.g., when the count is greater than 0).
  
  1. In the **Actions** section, select or create an action group (which can send emails, SMS, etc.).
  
  1. Configure the **Alert rule details** (name, description, severity).
  
  1. Click **Create alert rule**.
  

Step 4: Test Your Alerts

1. Simulate a failure in one of your migration tasks.
2. Check if the alert triggers and you receive the notifications as expected.

Additional Tips

• You can also use Azure Functions or Logic Apps to create more complex alerting mechanisms if needed.
• Regularly review the performance metrics and logs for proactive monitoring.

This setup should give you a good start in monitoring your Azure DMS tasks and receiving alerts when any task fails. If you need more specific guidance based on your scenario, feel free to ask!