Articles → MICROSOFT AZURE → Azure SQL Server Databases

Azure SQL Server Databases

Steps

1. Go to the SQL databases in the Azure portal
2. In the SQL databases, click on the +Add button

Click to Enlarge


3. In the details screen, enter the Subscription, Resource Group and Database name

Click to Enlarge


4. Select the server. If the server does not exist then create a new server using the Create new link

Click to Enlarge


5. Select the fields Want to use SQL elastic pool? and Compute + Storage
6. Click on the Review + create button

Click to Enlarge


7. Once the validation is done, click on the Create button to create the SQL server

Deployment Models

1. Single database - This is the single isolated database
2. Elastic pool - The elastic pool is the collection of single databases with shared resources

Purchasing Model

1. DTU based - DTU (Database Transaction Unit) is a combination of compute, memory, and storage as a single unit




Click to Enlarge

If the requirement comes to increase the resources, then new DTUs would be added. In other words, individual components cannot be upgraded to cater to the need of the increased demand.


2. vCore - In the case of VCore - compute, memory and storage can be upgraded individually. In other words, vCore gives more flexibility than DTUs




Click to Enlarge


3. Serverless - In this model, the cost is calculated based on usage. The billing is done on the amount of compute used per second

Service Tiers

1. General purpose/standard service tier - This service tier is used for applications with the standard workload
2. Business Critical/Premium - This service tier is used for OLTP applications
3. Hyperscale - This service tier is used for large OLTP applications and has the ability to autoscaling