Generally Available: I/O Performance Analysis—SQL Server on Azure Virtual Machines

We’re excited to announce that I/O Analysis for SQL Server on Azure Virtual Machines is now generally available. This powerful feature, accessible in the Azure portal, helps you optimize your SQL Server workloads by identifying I/O performance bottlenecks caused by virtual machine (VM) or disk throttling. With its clear metrics and actionable insights, you can enhance performance, identify latency, and help ensure your applications run smoothly. Whether you’re managing critical databases or scaling operations, this feature empowers you to fine-tune your storage performance. 

 

In addition, you can assess your storage performance health at a glance and apply key best-practice rules to ensure optimal alignment. 

 

If the analysis detects no I/O latency issue or problematic VM or disk I/O throttling in your system, you see a green checkmark to let you know the storage is healthy. If the analysis detects an underlying issue—either with disk latency at the VM or disk level, or an issue with storage caching—the feature pinpoints the level of impact and the date and time the issue occurred. 

 

Additionally, when you need to track I/O-related best practices, you can execute a small subset of the SQL Server best practices assessment rules against your SQL Server instance and use historical data to analyze the latest results. 

Learn more