Azure SQL Database Purchasing Models and Service tiers Module -2 | 🔥 Free Azure SQL DBA Training 🔥

In this video, you will get details information on Azure SQL Database Purchasing Models or Service tiers
Database Pricing or Purchasing Models or Service tiers:-
*DTU*:
The DTU purchasing model measures performance in DTUs instead of CPU and memory. Each DTU level and service tier provides predictable performance. The higher the DTU, the better the performance
VCore:
1. Memory and I/O are defined per vCore and depend on the hardware generation and the service tier. vCore and storage are to be selected separately and are therefore priced separately.
The vCore purchasing model also allows the use of existing SQL Server licenses at discounted rates for SQL managed databases under Azure Hybrid Benefit. you can surrender the on-premise licenses while doing the migration.
Timestamps:
00:01 SQL Database Purchasing Models or Service tiers
05:21 How to configure Purchasing Models or Service tiers for Azure SQL
Join the group: t.me/sqlbrainbox
Book 1:1 Call: topmate.io/nirav_gandhi
Follow me on LinkedIn: / niravgandhisql
Create an Azure Account: azure.microsoft.com/en-in/free/
Azure Document:docs.microsoft.com/en-in/azur...
how much does azure SQL cost?
How to change Change Azure SQL Database Pricing Tier?
#Azurepricingtiers #azuresqldatabase #Servicetiers #AzureSQLDBATraining

[@Niravgandhi]

💣🔥ruclips.net/p/PL9aNQqB-xjbCUkpXNzGV1A8v7JGUgCpZY

[@stephenadams2397]

Great overview. Thank you. Good catch on that SQL server size too. Almost got a big bill!

[@srinivasmerugu8029]

Awesome. Superb explanation

[@Niravgandhi]

Thanks

[@rohithravindran100]

great explanation with good detailed practical video.. easily understandable. Thanks a lot :)

[@Niravgandhi]

Most welcome!

[@sathyar7078]

Good explanation . Post more videos in Azure

[@Niravgandhi]

Thanks

[@bhagyeshspathak]

Great video @Niravgandhi !
I have two questions that I'm struggling with and if you can help me with.
Q1. If I choose Pay-as-you-go in the first subscription tier and then with the lowest DTU, say ~ Rs. 350 per month, does that mean I will be charged only 350 rupees and nothing more? In that case, what is the significance of "pay as you go" column?
Q2. Also, I'm trying to get an estimate on the required DTUs as explained in one of your other videos. I'm building a small MS Access database for one of the clients. I will need to migrate it to Azure in 6 months. How do I get some estimate on what DTU tier I would require? I need to plan the client budget accordingly.
Thank you so much for the deep demo, appreciate it!

[@SK-qm5py]

Sir ..i tried to create a Sql database ..it is showing Estimated cost per month as 384.63 ...
What does that mean ...
will it get deducted from free trail account's credit of 15,800 ?
OR
should i pay this 384.63 as my credit card bill 😳?

[@Niravgandhi]

Check Currency options in Subscriptions

[@Gopal_5143]

Adventure works has not came in my system along withdata base
What should i do?
Shall i install saperately

[@Niravgandhi]

you can download from internet, it's available in GitHub

[@Gopal_5143]

Ok bro