We've got around 400 production databases that we've just flipped from the Web data tier to the Basic and standard tiers.  I'm trying to set up alerts to monitor DTU percentage.  I really don't want to have to manually do this for all 400 databases through the portal.  I'm hoping I can set up the alerts through powershell, the apis, or the Azure SDK.  So far, I haven't had any luck.  Does anyone know if this is possible?

Check the blog post at http://blogs.technet.com/b/keithmayer/archive/2014/11/08/scripts-to-tools-automate-monitoring-alert-rules-in-microsoft-azure-with-powershell-and-the-azure-service-management-rest-api.aspx

The REST API doc is at https://msdn.microsoft.com/en-us/library/dn510366.aspx

Resource id is {subscriptionId}/services/sqlservers/servers/{serverName}/databases/{databaseName}

The metric names supported are

• cpu_percent
• physical_data_read_percent
• log_write_percent
• dtu_consumption_percent
• storage
• connection_successful
• connection_failed
• blocked_by_firewall
• deadlock

• Proposed as answer by Jan EngelsbergMicrosoft employee 11 hours 15 minutes ago

Check the blog post at http://blogs.technet.com/b/keithmayer/archive/2014/11/08/scripts-to-tools-automate-monitoring-alert-rules-in-microsoft-azure-with-powershell-and-the-azure-service-management-rest-api.aspx

The REST API doc is at https://msdn.microsoft.com/en-us/library/dn510366.aspx

Resource id is {subscriptionId}/services/sqlservers/servers/{serverName}/databases/{databaseName}

The metric names supported are

• cpu_percent
• physical_data_read_percent
• log_write_percent
• dtu_consumption_percent
• storage
• connection_successful
• connection_failed
• blocked_by_firewall
• deadlock

• Proposed as answer by Jan EngelsbergMicrosoft employee 11 hours 5 minutes ago

Check the blog post at http://blogs.technet.com/b/keithmayer/archive/2014/11/08/scripts-to-tools-automate-monitoring-alert-rules-in-microsoft-azure-with-powershell-and-the-azure-service-management-rest-api.aspx

The REST API doc is at https://msdn.microsoft.com/en-us/library/dn510366.aspx

Resource id is {subscriptionId}/services/sqlservers/servers/{serverName}/databases/{databaseName}

The metric names supported are

• cpu_percent
• physical_data_read_percent
• log_write_percent
• dtu_consumption_percent
• storage
• connection_successful
• connection_failed
• blocked_by_firewall
• deadlock

• Proposed as answer by Jan EngelsbergMicrosoft employee Wednesday, July 15, 2015 8:03 PM

Check the blog post at http://blogs.technet.com/b/keithmayer/archive/2014/11/08/scripts-to-tools-automate-monitoring-alert-rules-in-microsoft-azure-with-powershell-and-the-azure-service-management-rest-api.aspx

The REST API doc is at https://msdn.microsoft.com/en-us/library/dn510366.aspx

Resource id is {subscriptionId}/services/sqlservers/servers/{serverName}/databases/{databaseName}

The metric names supported are

• cpu_percent
• physical_data_read_percent
• log_write_percent
• dtu_consumption_percent
• storage
• connection_successful
• connection_failed
• blocked_by_firewall
• deadlock

• Proposed as answer by Jan EngelsbergMicrosoft employee Wednesday, July 15, 2015 8:03 PM
• Marked as answer by Casey KarstMicrosoft employee, Moderator 15 hours 30 minutes ago

Check the blog post at http://blogs.technet.com/b/keithmayer/archive/2014/11/08/scripts-to-tools-automate-monitoring-alert-rules-in-microsoft-azure-with-powershell-and-the-azure-service-management-rest-api.aspx

The REST API doc is at https://msdn.microsoft.com/en-us/library/dn510366.aspx

Resource id is {subscriptionId}/services/sqlservers/servers/{serverName}/databases/{databaseName}

The metric names supported are

• cpu_percent
• physical_data_read_percent
• log_write_percent
• dtu_consumption_percent
• storage
• connection_successful
• connection_failed
• blocked_by_firewall
• deadlock

• Proposed as answer by Jan EngelsbergMicrosoft employee Wednesday, July 15, 2015 8:03 PM
• Marked as answer by Casey KarstMicrosoft employee, Moderator Monday, July 20, 2015 3:38 PM

Check the blog post at http://blogs.technet.com/b/keithmayer/archive/2014/11/08/scripts-to-tools-automate-monitoring-alert-rules-in-microsoft-azure-with-powershell-and-the-azure-service-management-rest-api.aspx

The REST API doc is at https://msdn.microsoft.com/en-us/library/dn510366.aspx

Resource id is {subscriptionId}/services/sqlservers/servers/{serverName}/databases/{databaseName}

The metric names supported are

• cpu_percent
• physical_data_read_percent
• log_write_percent
• dtu_consumption_percent
• storage
• connection_successful
• connection_failed
• blocked_by_firewall
• deadlock

• Proposed as answer by Jan EngelsbergMicrosoft employee Wednesday, July 15, 2015 8:03 PM
• Marked as answer by Casey KarstMicrosoft employee, Moderator Monday, July 20, 2015 3:38 PM

Check the blog post at http://blogs.technet.com/b/keithmayer/archive/2014/11/08/scripts-to-tools-automate-monitoring-alert-rules-in-microsoft-azure-with-powershell-and-the-azure-service-management-rest-api.aspx

The REST API doc is at https://msdn.microsoft.com/en-us/library/dn510366.aspx

Resource id is {subscriptionId}/services/sqlservers/servers/{serverName}/databases/{databaseName}

The metric names supported are

• cpu_percent
• physical_data_read_percent
• log_write_percent
• dtu_consumption_percent
• storage
• connection_successful
• connection_failed
• blocked_by_firewall
• deadlock

• Proposed as answer by Jan EngelsbergMicrosoft employee Wednesday, July 15, 2015 8:03 PM
• Marked as answer by Casey KarstMicrosoft employee, Moderator Monday, July 20, 2015 3:38 PM