Announcing major performance improvements for Azure SQL Database Managed Instances

%3CLINGO-SUB%20id%3D%22lingo-sub-1731301%22%20slang%3D%22en-US%22%3EAnnouncing%20major%20performance%20improvements%20for%20Azure%20SQL%20Database%20Managed%20Instances%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1731301%22%20slang%3D%22en-US%22%3E%3CP%3EAzure%20SQL%20Managed%20Instance%20is%20a%20fully-managed%2C%20secure%2C%20and%20always%20up-to-date%20SQL%20instance%20in%20the%20cloud.%20It%20provides%20state-of-the-art%20capabilities%20and%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fsqlmi-slas%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Eindustry-leading%20SLAs%3C%2FA%3E%2C%20allowing%20you%20to%20easily%20migrate%20and%20modernize%20your%20mission-critical%20applications%20in%20Azure.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAzure%20SQL%20Managed%20Instance%20is%20constantly%20being%20improved%20based%20on%20the%20customer%20feedback.%20There%20are%20many%20important%20updates%20to%20Managed%20Instances%20that%20will%20be%20launched%20as%20part%20of%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fmyignite.microsoft.com%2Fhome%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EIgnite%202020%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Evirtual%20conference%20(more%20details%20to%20follow%20in%20the%20upcoming%20blog%20posts)%2C%20but%20in%20this%20post%20we'll%20go%20deeper%20into%20the%20recent%20improvements%20in%20the%20areas%20of%20performance%20and%20cost%20efficiency.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CH2%20id%3D%22toc-hId--1241888240%22%20id%3D%22toc-hId--1241888204%22%3ESignificantly%20improved%20transaction%20log%20write%20throughput%3C%2FH2%3E%3CP%3EWe%20have%20significantly%20improved%20the%20transaction%20log%20write%20throughput%20(often%20referred%20to%20as%20%22log%20rate%22)%20for%20the%20Azure%20SQL%20Managed%20Instances%2C%20greatly%20improving%20the%20overall%20performance%20for%20usage%20scenarios%20such%20as%20data%20ingestion%20and%20index%20maintenance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20following%20table%20and%20the%20diagram%20summarize%20the%20improvements%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fazure-sql%2Fannouncing-major-performance-improvements-for-azure-sql-database%2Fba-p%2F1701256%22%20target%3D%22_self%22%3E%3CSTRONG%3EContinue%20reading%3C%2FSTRONG%3E%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1731301%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20SQL%20Database%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

Azure SQL Managed Instance is a fully-managed, secure, and always up-to-date SQL instance in the cloud. It provides state-of-the-art capabilities and industry-leading SLAs, allowing you to easily migrate and modernize your mission-critical applications in Azure.

 

Azure SQL Managed Instance is constantly being improved based on the customer feedback. There are many important updates to Managed Instances that will be launched as part of Ignite 2020 virtual conference (more details to follow in the upcoming blog posts), but in this post we'll go deeper into the recent improvements in the areas of performance and cost efficiency.

 

Significantly improved transaction log write throughput

We have significantly improved the transaction log write throughput (often referred to as "log rate") for the Azure SQL Managed Instances, greatly improving the overall performance for usage scenarios such as data ingestion and index maintenance.

 

The following table and the diagram summarize the improvements:

 

Continue reading

0 Replies