Azure Advisor Opmization Workbook New Ideas request

📝 Scenario

I am part of the Finops Team here at KPMG, and we extensively use the optimization workbook for our operations. We have identified some new ideas which would provide more value to the optimization workbook and will help us fulfill our daily task much effectively.
As a <TODO: What persona is this for?>, I need to <TODO: What action does the user need to perform?> in order to <TODO: What is the goal? Why is this needed?>

💎 Solution

Ideas.

1. Flexibility to setup alerts in Optimization workbook. The goal is that we can setup email alert so that when a new orphaned resources/ recommendation is added to the workbook we can get an alert in our inbox. Right we need to manually check everyday if any new resources are added.

2. Cost Details.
   Cost breakout by orphaned resource category: It would be a nice feature to include the cost information for the orphaned resources. Right now we need to manually check the details in the cost management tool.
   Cost Anomaly
   It would be helpful if Cost Anomaly alerts were aggregated into a central view, such as a table. right need to manually check insights in each subscriptions.

3. Addition of New Services: It would be helpful to expand the services covered in the workbook.
   Some of the services which are looking at is

• Azure Databricks
• Cognitive Services
• Azure Data Factory v2
• Defender for cloud (existing workbook only provide cost for different plans and total cost)
• Application insights etc.

4. Rightsizing Recommendations across services:

• SQL Database rightsizing based on current utilization. Right now we can see we have only Idle SQL databases
• Insights about SQL Database retention policies, similar to Recovery Services Vault in Backup Center
• Managed disk capacity under-utilization to reduce cost
• Rightsizing recommendations for minimum Autoscale instances for App service plans, Application gateway based on current utilization
• Premium File shares underutilized provisioned capacity
• Storage Account Access tier change for Blobs based on access pattern
• App service Plan rightsizing
• Azure Synapse Analytics rightsizing
• Azure SQL Managed instances rightsizing
• Azure Redis Cache rightsizing

5. Idle instances addition

• Idle VPN gateways
• Unhealthy Backend pools for App gateway
• Idle VM for last 3months
• Storage not accessed for last 3months
• SQL Elastic Pools without DB's
• Disk Attached to stopped instances
• idle Load Balances with Low traffic

Please ignore if you see any ideas which are already implemented and duplicated.

ℹ️ Additional context

TODO: Add any other context or screenshots about the change request, including alternative solutions you considered and why you ruled them out.

🙋‍♀️ Ask for the community

We could use your help:

1. Please vote this issue up (👍) to prioritize it.
2. Leave comments to help us solidify the vision.