I setup a lot of DTU alerts for our PROD Databases and setup some low threasholds to test the alerts and none of them fired. I even witnessed 3 DBs above my threashold for more a good 30 min but never an email.

something broken with the alerts?

Chris,

  Thanks for reporting this issue. We are aware of this issue and actively working on resolving it. Apologies for any inconvenience caused here.

Srini

Thanks Srini,

Is there an API i can link with to monitor the usage on my end? We just switched to the new tiers and it's critical to be able to monitor and react to any high DTU usage.

Chris,

You can query the DMV sys.dm_db_resource_stats frequently to monitor the resource usage at 15 second granularity for the last one hour. (http://msdn.microsoft.com/en-us/library/dn800981.aspx). Documentation here also has an example query to get the average DTU consumption.

-- Srini

• Marked as answer by Simon_HouMicrosoft contingent staff, Moderator Thursday, October 09, 2014 8:52 AM

Chris,

You can query the DMV sys.dm_db_resource_stats frequently to monitor the resource usage at 15 second granularity for the last one hour. (http://msdn.microsoft.com/en-us/library/dn800981.aspx). Documentation here also has an example query to get the average DTU consumption.

-- Srini

• Marked as answer by Simon_HouMicrosoft contingent staff, Moderator Thursday, October 09, 2014 8:52 AM

Chris,

You can query the DMV sys.dm_db_resource_stats frequently to monitor the resource usage at 15 second granularity for the last one hour. (http://msdn.microsoft.com/en-us/library/dn800981.aspx). Documentation here also has an example query to get the average DTU consumption.

-- Srini

• Marked as answer by Simon_HouMicrosoft contingent staff, Moderator Thursday, October 09, 2014 8:52 AM

Chris,

You can query the DMV sys.dm_db_resource_stats frequently to monitor the resource usage at 15 second granularity for the last one hour. (http://msdn.microsoft.com/en-us/library/dn800981.aspx). Documentation here also has an example query to get the average DTU consumption.

-- Srini

• Marked as answer by Simon_HouMicrosoft contingent staff, Moderator Thursday, October 09, 2014 8:52 AM

I am having an issue where the alerts are not sending email for firewall blocks and failed login attempts.

Has this been fixed or is there more to configure than just the alert itself?

Thank you in advance.

Kenny