How do you use cloud databases? Take the survey.

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

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).

Best Answer

Sign In or Register to comment.