Optimize Azure SQL Database Performance

Question

Do we need to run update statistics after running rebuild index in Azure PaaS servers. We are currently running Rebuild index through runbook automation. Also need to know if we can get email notification on failure of Automation Runbook.

PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help the Azure community.

Answer 1

Greetings !

When rebuilding an index, azure SQL database server does indeed update the associated statistics for that index. However, it’s essential to consider non-index statistics as well.  You can use below stored procedure to implement the maintenance using the same which will take care of both indexing and stats.

you can configure alerts notification to Monitor runbooks with metric alerts. Please refer below documents for detailed information.

Please follow the below documents for more information. 

https://techcommunity.microsoft.com/t5/azure-database-support-blog/how-to-maintain-azure-sql-indexes-and-statistics/ba-p/368787 

https://techcommunity.microsoft.com/t5/azure-database-support-blog/automating-azure-sql-db-index-and-statistics-maintenance-using/ba-p/368974 

https://learn.microsoft.com/en-us/azure/automation/automation-alert-metric

Regards

Geetha