Hi @sakuraime From the hardware configuration perspective, this section showcases the limits and if/how they can be adjusted: Resource limits - Azure SQL Managed Instance | Microsoft Learn
Regards,
Oury
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
in Azure SQL managed instance , sometimes I see their are some log generation throttling on the os_wait_stats , or from exec_request wait .
how to get rid of it except by upgrade to high tier ?
Is it there is a build in resource governor for that ? Can we disabled it ?
below is the reference
https://azure.microsoft.com/en-us/blog/key-causes-of-performance-differences-between-sql-managed-instance-and-sql-server/
And also , create a database under Azure sql mi with a larger size will help to increase the performance ,,, on Business Critical tier
Hi @sakuraime From the hardware configuration perspective, this section showcases the limits and if/how they can be adjusted: Resource limits - Azure SQL Managed Instance | Microsoft Learn
Regards,
Oury
"Unfortunately, there are no corrective actions that you can do to prevent this issue. Limit on the log rate is the price that must be taken to always ensure that the backups are taken.
If you are migrating your databases from SQL Server to Managed Instance you can repeat this experiment on your SQL Server instance to check what are the instance log limits that you have and could your workload run on the Managed Instance with the same performance. Just make sure that you are using the version built for your version of SQL Server."
Source: Log rate throughput cap on Managed Instance.
Jovan was part of the team that brought to live Managed Instance although he is no longer serving in that team, for me he is the must trusted source about Managed Instance even over Microsoft Learn.