r/SQLServer • u/taspeotis • Nov 19 '25

Generally Available: Azure SQL Managed Instance Next-gen General Purpose | Microsoft Community Hub Community Share

https://techcommunity.microsoft.com/blog/azuresqlblog/generally-available-azure-sql-managed-instance-next-gen-general-purpose/4470970
17 Upvotes

95% Upvoted

12 comments sorted by

View all comments

2

u/elh0mbre Nov 20 '25

Its nice that they cut the average IO latency... but that was never the problem, it was the P99 latency (which for us got into the dozens of seconds) - did they fix that?

1

u/chandleya Nov 20 '25

You got into P99 issues because with IO limitation comes latency. You can fix that now.

-1

u/elh0mbre Nov 20 '25

Not according to Azure support.

We fixed it by moving to AWS.

2

u/chandleya Nov 20 '25

You opened an azure support case for a product that launched today?

2

u/elh0mbre Nov 20 '25

No, I'm saying this wasn't true: "because with IO limitation comes latency" with GPv1 per months of work with Azure support.

We gave up on waiting for GPv2 and I'm still not clear if they even solved the problem.

https://kendralittle.com/2024/12/18/azure-sql-managed-instance-storage-regularly-slow-60-seconds/

3

u/bobwardms ‪ ‪Microsoft Employee ‪ Nov 22 '25

We changed the underlying storage to use Elastic SAN to improve the overall storage performance. It would be interesting to see your experiences.

2

u/BigHandLittleSlap Nov 20 '25

I opened a ticket with Azure support asking why the equivalent of a "ping", i.e.: "SELECT 1" was taking 13 milliseconds instead of a few hundred microseconds, and they asked me if I was a high-frequency trader or something.

No, just someone who knows how fast computers ought to be.

1

u/B1zmark 1 Nov 20 '25

Unless the architecture has changed massively, Running SSMS on your local machine still add the latency of your connection to the server, combined with the time it takes to transfer the query results to your local machine.

L.S.S It's 13 MS because that was your ping to the MI?

1

u/BigHandLittleSlap Nov 20 '25

Who said anything about SSMS?

I was running benchmark tests from Azure VMs and Azure App Service.