Azure MI automatic auto scaling

Question

want to know that automatic auto scaling is possible in azure MI

Answer 1

Hi Mohd Azeem Ali khan,
Thankyou For Reaching microsoft Q&A!
It sounds like you’re curious about whether automatic auto-scaling is possible in Azure MI (Managed Instance).

Here's an overview of the scaling capabilities related to Azure Managed Instance:

1. Azure SQL Managed Instance Scaling: Azure SQL Managed Instance supports scaling either up or down within the same service tier or even to a different service tier. You can adjust the compute size and storage to better accommodate your workload. While there isn't a direct auto-scaling feature built into Azure SQL Managed Instance like you would see in Azure DocumentDB, you can use automation tools such as Azure Automation Runbooks to potentially achieve similar results based on your specific needs.
2. Autoscale Features: Automatic adjustments based on varying workloads can be implemented through Azure’s monitoring and automation features, albeit it's manual in the sense that you'd have to set up triggers (like Azure Monitor Alerts) that initiate a Runbook to perform scaling actions.

To sum it up, while automatic auto-scaling isn't natively available with a single click for Azure Managed Instances, you can implement custom autoscale strategies using Azure Automation and monitoring tools.

If you're looking for more specific guidance or have other questions, here are some follow-up questions that could help clarify your needs:

1. What specific workloads do you expect to vary that would require auto-scaling?
2. Are you familiar with using Azure Automation or creating Runbooks for such tasks?
3. Do you currently have a monitoring solution to track performance metrics for your manage instance that can trigger scaling actions?

Hope this helps you get started, and feel free to ask more questions!

References:

• Azure SQL Managed Instance Resource Limits
• Azure SQL Managed Instance Auto-Failover Groups
• How to Auto-Scale Azure SQL Database

Note: This content was drafted with the help of an AI system. Please verify the information before relying on it for decision-making.