Add cost recommendations for Azure SQL DB and Managed instance
It would be beneficial to have recommendations presented in Azure Advisor for Azure SQL DB / MI. Below an example of where it would be helpful to have additional insights.
My example is driving on a Service Owner and Architect within a Cloud Competence Center. Their role is facilitating information (like cost insights) and also help with making architecture decisions before DevOps teams start their project.
The internal customers of the CCC are departments like Business Intelligence teams, development teams, departments with external vendors deploying applications.
All these personas have different cloud skills:
* BI and Developer teams that know what they're doing and make conscious decisions.
* Developers that just want the job done but don't really care about tiers and costs. So, Dev but no Ops.
* External vendors that might or might not have an idea of their workload and use tiers that simply will do the job (Premium or BC all the way).
Having additional auto-generated insights, considerations and/or recommendations based on the workload and usage patterns would be great to open up an advisory discussion with the internal customers.
Of course, context is key (for example SLA) but it would be a nice conversation starter.
Attached some cost advisor topics I'm currently thinking about.
Santhosh Veettil commented
Please add this feature in cost advisor