Category: Database Performance

SQL Server Managed Instance IO Performance

SQL Server Managed Instance IO Performance is dependant on a few settings. Service Tier vCore Count  File Sizes !! Yes, File Sizes. A quick explanation, if you have a small database < 128GB your not going to get much data throughput. Only around the 500 IOPS or 100 MB/s. It’s all explained here. https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits You […]