search

MicrosoftDocs / azure-docs

Open source documentation of Microsoft Azure
https://docs.microsoft.com/azure
Creative Commons Attribution 4.0 International
10.24k stars 21.41k forks source link

Hyperscale scaling SLAs #96256

Closed VitalyMCT closed 2 years ago

VitalyMCT commented 2 years ago

The blog post at https://azure.microsoft.com/en-ca/blog/resource-governance-in-azure-sql-database mentions the following:

image

However, the latest SLA page at https://azure.microsoft.com/en-ca/support/legal/sla/azure-sql-database/v1_8 does not mention any scaling SLAs for Hyperscale. Neither does this official documentation page. Can you please advise where to locate them?

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

GeethaThatipatri-MSFT commented 2 years ago

@VitalyMCT Thanks for reaching out, We will Investigate and update you shortly.

VitalyMCT commented 2 years ago

Thanks @GeethaThatipatri-MSFT.

Additional info. The https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-scale page states this for Hyperscale:

Constant time latency independent of space used. Typically, less than 2 minutes.

However, this seems to be "best effort" timing, not an SLA. And my client has seen multiple-hour scaling performance, so significantly slower than this 2 minute duration.

dimitri-furman commented 2 years ago

Hi @VitalyMCT - thanks for bringing this up. You are correct that there is not an official SLA for scaling in Hyperscale, or for that matter in any other Azure SQL Database service tier. The blog is misleading in that sense. We will be updating it to remove the reference to a "scaling SLA".

The documentation article you mentioned in your follow-up message describes typical and representative scaling times for various scaling operations. 2 minutes or less is what we see across the fleet of all Hyperscale databases, at high percentile. These times are, however, not guaranteed and not a part of any official SLA.

The only official SLA Azure SQL Database provides is published at https://azure.microsoft.com/support/legal/sla/azure-sql-database/.

VitalyMCT commented 2 years ago

Thanks @dimitri-furman. I appreciate the clarification around the statement in the blog.

I figured it might've been out of date, as that post is about 3 years old. However, it's always great to get confirmation on these things from the official source, rather than have me assume things.

GeethaThatipatri-MSFT commented 2 years ago

Thanks, @dimitri-furman for providing the detailed information. Hi @VitalyMCT We will proceed to close this issue now. If there are further questions regarding this, please comment and we will gladly continue the discussion.