I encourage you to apply this level of protecting to your SQL Databases. When deploying them, consider a few test cases that could generate these alerts, and test them to make sure they work as you expect!

Index Advisor

Having a PaaS database does not mean you can ignore fundamental database design decisions such as data types and indexes. SQL Database won’t automatically create or remove indexes, or reorganize or rebuild them.

But, much like we have Database Engine Tuning Advisor (DTA) in the on-premises versions of SQL Server, SQL Database has Index Advisor. This is designed to provide you with index recommendations based on your current SQL Database workload. To access it, open your SQL Database settings on the portal and select Index Advisor. If your database has had activity, you will see index recommendations. The indexes can be applied one at a time from the portal or via T-SQL, or you can automatically apply all of them. (I wouldn’t choose that last option!)

I’d like to do more research on this before I can definitely recommend it, especially after seeing much DTA index abuse over the years. But I’m glad to see that the Azure team is working to make developing indexes against a database easier.