DTU vs vCore
- Refer Here for understanding vCore vs DTU
- For using DTU’s azure recommends users to use the calculator as mentioned over here
- vCore is all about choosing custom CPU and storage unlike DTU.
- In vCore we have two compute tiers
- Provisioned:
- Guaranteed Speed/Performance consistently so use this for databases which are used all the time
- Serverless:
- Use this for inconsistenly used datbases, Can save the bills if your database is not consistently used throughout the data
- Use this for inconsistenly used datbases, Can save the bills if your database is not consistently used throughout the data
- Provisioned:
Reservations
- Microsoft further reduces the bills for reservations, you can give a commitment to use a database for 1 or 3 years and you can save a lot of amount. Refer Here
Azure CLI To create SQL Server
- Launch Cloudshell
]
- If you are creating cloud shell for first time, you will observe a prompt for storage creation and create it
- Select Bash for this exercise, but Azure cli works in powershell also
- Now create a SQL Server from Azure CLI following this document
Azure Powershell to Create SQL Server
- Launch Cloudshell
]
- If you are creating cloud shell for first time, you will observe a prompt for storage creation and create it
- Select Powershell for this exercise
- Now Create a SQL Server from Azure Powershell following this document