Azure SQL Monitoring - suppress DTU/IO warnings during index/stats maintenance?

paschott

We have a couple of Azure Runbooks that fire a couple of times during the day. These are to update the stats and maintain indexes. We run the stats updates during the day and index maintenance at night. This causes a lot of IO so we start getting warnings about DTU usage.  As far as I can tell, there's no way to set multiple maintenance windows and because these are on IO/DTU and not a long-running query, there doesn't seem to be a way to ignore them based on text in the query.

Any suggestions on how we might work around this? We're trying to find a decent solution that can alert as needed while not sending out alerts for "normal" maintenance activities (even if they have a high impact temporarily).

Russell D

Currently there isn't a workaround I'm afraid.

Revisiting the maintenance window is high on our priority list though.