What is the Azure SQL database equal configuration for Gen 4 vCore 24

Question

What is the Azure SQL database equal configuration for Gen 4 vCore 24

Sunil Gudipati (iTalent Corporation) 0 Microsoft External Staff

Currently we are using Gen 4 and vCore is 24. What is the Azure SQL database equal configuration for Gen 4 vCore 24 as it is going retire by march 1st.

SSingh-MSFT 16,371 Reputation points Moderator

2023-03-06T04:28:29.22+00:00

Hi @Sunil Gudipati (iTalent Corporation) ,

Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.
Sunil Gudipati (iTalent Corporation) 0 Reputation points Microsoft External Staff

2023-03-06T04:47:08.37+00:00

That may be correct, but we opted for a serverless, auto-scalable solution because we require more connections at times.

2 answers

Your answer

SSingh-MSFT 16,371 Reputation points Moderator

2023-03-06T04:28:29.22+00:00

Hi @Sunil Gudipati (iTalent Corporation) ,

Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.
Sunil Gudipati (iTalent Corporation) 0 Reputation points Microsoft External Staff

2023-03-06T04:47:08.37+00:00

That may be correct, but we opted for a serverless, auto-scalable solution because we require more connections at times.

Answer 1

Alberto Morillo 34,671 MVP Volunteer Moderator

The following are more or less equivalent service tiers in the Azure SQL DTU-model:

Azure SQL Standard S9 offers 24 cores with a 12 maxdop (maximum degree of parallelism)
Azure SQL Standard S12 offers 44 cores with a 22 maxdop
Azure SQL Premium (high performance IO) P11 offers 18 cores with a 18 maxdop
Azure SQL Premium (high performance IO) P15 offers 42 cores with a 42 maxdop

With Azure SQL DTU model you don't have to pay licensing fees.

Sunil Gudipati 0 Reputation points

2023-03-28T05:27:12.1633333+00:00

Hi Alberto,

Thank you very much our problem was fixed with P11. It is beneficial for us. We are seeing faster execution comparatively 24 vCore.

Thank you,

Sunil
SSingh-MSFT 16,371 Reputation points Moderator

2023-03-29T05:10:52.03+00:00

Hi @Sunil Gudipati (iTalent Corporation) , Sunil Gudipati,

Good to know that the answer provided by Alberto is useful.

We recommend you to Accept Answer and Mark it as Helpful by using the same User ID from which you have raised the question. This benefits the community to find correct answers.

Kindly login to sunilgudipatiitalentcorporation-4335/ profile and Accept the answer. We encourage not to use two different profiles on same question. Let us know if you have any queries. Thanks

Answer 2

SSingh-MSFT 16,371 Moderator

Hi @Sunil Gudipati (iTalent Corporation) ,

Thanks for the reply.

If you are looking for autoscalable option, please take a look at the Hyperscale service tier.

Hyperscale is best for the widest variety of workloads. Autoscaling storage size up to 100 TB, fast vertical and horizontal compute scaling, fast database restore.

Reference links: Hyperscale service tier

Migrate an existing database to Hyperscale

Hope this information helps. If you have further queries do let us know.

Thanks

SSingh-MSFT 16,371 Reputation points Moderator

2023-03-10T07:19:40.0833333+00:00

Hi @Sunil Gudipati (iTalent Corporation) ,

Just checking in to see if the above suggestion helped. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.

Share via

What is the Azure SQL database equal configuration for Gen 4 vCore 24

2 answers

Your answer