Azure SQL Database - How to choose the correct specs

Question

Hi everyone, hope all is well.

I would like to commission an Azure SQL Database however I do not understand the vCore/DTU options and what they mean.

I do however have an idea of the specs i would need for the server which is around 8 cores 32gb ram.

Would it be possible for someone to recommend the optimal settings to choose when selecting the specs?

Thanks in advance to any assistance provided.

Answer 1

WIth Azure SQL Database DTU-model S7 service tier the database will 12 cores available, max degree of parallelism 8, and 53 MB of RAM. That is the one that best adjust for your needs.

Answer 2

Hi shane.beharry Thank you for reaching out.

Azure SQL Database offers two purchasing models: vCore-based and DTU-based. vCore-based purchasing model offers more flexibility and control over the performance of your database. DTU-based purchasing model offers a pre-defined set of performance levels based on a blended measure of CPU, memory, and read and write rates.

In addition to @Alberto Morillo answer. You can also choose the vCore-based purchasing model and selecting the General-Purpose service tier with 8 vCores and 32 GB of storage. This should provide the performance and scalability you need for your database.

For more info see:

vCore purchasing model - Azure SQL Database

Compare vCore and DTU-based purchasing models of Azure SQL Database

Hope that help.

Regards,

Oury