Azure SQL Databases - Architecture
You 'll be having an Azure subscription as the
top layer in which you have a resource group. Within the resource group, you'll
be having the server instances and databases. On top of the SQL database
server, it contains the master database and isolated users database.
PowerShell commands
The
PowerShell commands to deploy the Azure SQL database are:
To
build a SQL server:
$sqlServer = New-AzureRmSqlServer -ServerName $sqlServerName -SqlAdministratorCredentials
$creds -Location $sqlServerLocation -ResourceGroupName $resourceGroupName -ServerVersion
$sqlServerVersion
To
Create an empty database in the server:
$CurrentDatabase = New-AzureRmSqlDatabase -ResourceGroupName $resourceGroupName
-ServerName $sqlServerName -DatabaseName $databaseName -Edition $databaseEdition
-RequestServiceObjectiveName $databaseServiceLevel
Database Tiers
There
are different tiers in SQL Databases offered by Azure which can be selected
depending on the use case they are:
·
Basic - for databases
that have a single active operation, or for dev and test deployments.
·
Standard - for low to
medium input/output databases and supports concurrent queries, as well as Azure
web applications.
·
Premium - The Premium
tier is designed for high transaction volumes and input/outputs. It supports
multiple concurrent users, and Microsoft recommends that you use this database
for mission-critical databases.
·
PremiumRS - This tier is
recommended for input/output intensive workloads when high availability is not
required. But you can use it for high-performance test and dev workloads.
Choosing Database Tier
SQL Database renders dynamically scalable performance in two
diverse purchasing models - a
vCore-based
purchasing model
and a DTU-based purchasing
model
.
·
vCore based model - In this model,
you can independently choose the computing and storage resources. It also lets
you use the Azure Hybrid Benefit for SQL Server to gain on your savings.
·
Database Transaction Units
(DTU) based model - This model is based on a combined measure of computing,
storage, and IO resources. Performance levels are expressed in terms of DTUs
for single databases and elastic DTUs (eDTUs) for elastic pools.
·
Logical servers
in Azure SQL
offers both purchasing models: a DTU-based purchasing model and a vCore-based
purchasing model.
·
Managed Instances
in Azure SQL
Database offer only the vCore-based purchasing model.
Comments
Post a Comment