[QUERY] SQL DB Hyperscale ServiceObjectiveName/Cores

[tlorton]

Query/Question What are the available options for the ServiceObjectiveName if the DatabaseEdition is Hyperscale?

When I create a Hyperscale DB, the ServiceObjectiveName default is Gen4 I believe. Is there a way to specify Gen5 and the amount of cores?

I found the list of ServiceObjectiveNames, but none of them seem to correlate to Hyperscale values. https://docs.microsoft.com/en-us/dotnet/api/microsoft.azure.management.sql.models.serviceobjectivename?view=azure-dotnet

• Basic
• DS100
• DS1000
• DS1200
• DS1500
• DS200
• DS2000
• DS300
• DS400
• DS500
• DS600
• DW100
• DW1000
• DW10000c
• DW1000c
• DW1200
• DW1500
• DW15000c
• DW1500c
• DW200
• DW2000
• DW2000c
• DW2500c
• DW300
• DW3000
• DW30000c
• DW3000c
• DW400
• DW500
• DW5000c
• DW600
• DW6000
• DW6000c
• DW7500c
• ElasticPool
• Free
• P1
• P11
• P15
• P2
• P3
• P4
• P6
• PRS1
• PRS2
• PRS4
• PRS6
• S0
• S1
• S12
• S2
• S3
• S4
• S6
• S7
• S9
• System
• System0
• System1
• System2
• System2L
• System3
• System3L
• System4
• System4L

Why is this not a Bug or a feature Request? Not a bug because creating a Hyperscale DB works as expected.

Setup (please complete the following information if applicable):

• OS: [Windows 10]
• IDE : [VS 2019 Enterprise]

• 1.27

  Information Checklist Kindly make sure that you have added all the following information above and checkoff the required fields otherwise we will treat the issuer as an incomplete report

  • [x ] Query Added
  • [x ] Setup information Added

[yaohaizh]

@tlorton currently this is not supported in this version of fluent .NET lib.

[tlorton]

@yaohaizh Is there a ServiceObjectiveName from those values that works with Hyperscale? I keep receiving errors like this: Microsoft.Rest.Azure.CloudException: Long running operation failed with status 'Failed'. Additional Info:'The edition 'Hyperscale' does not support the service objective 'Basic'.'

And yes I am aware that Basic will never work, just trying to prove a point.

[tlorton]

Is there a way Microsoft would recommend to create Hyperscale databases? Using Azure CLI?

[tlorton]

As a "workaround", a really helpful person helped me figure it out here: https://stackoverflow.com/questions/59277121/sql-db-hyperscale-serviceobjectivename-cores/59281290#59281290

[jeroenterheerdt]

hey @tlorton - not sure how this has escaped our attention for so long - sorry about that. Just to reply to your question, you can absolutely use Azure CLI to create Hyperscale databases: az sql db create -g mygroup -s myserver -n mydb -e Hyperscale --read-replicas 5. Hope this helps.

[tlorton]

That does not help as I am trying to using the azure-libraries-for-net SDK.

[jeroenterheerdt]

@tlorton - thanks. I'll let @yaohaizh respond to our plans here.