From the course: Azure Solutions Architect Expert (AZ-305) Cert Prep: Design Data Storage Solutions
Unlock the full course today
Join today to access over 23,200 courses taught by industry experts.
Purchasing models for Azure SQL DB and SQL MI - Azure Tutorial
From the course: Azure Solutions Architect Expert (AZ-305) Cert Prep: Design Data Storage Solutions
Purchasing models for Azure SQL DB and SQL MI
- Purchasing models for Azure SQL DB and Azure SQL MI have two main options. Database transaction units. These are a blended mix of compute storage and IO resources, available only on Azure SQL DB. The DTU was the first purchasing option available to those purchasing Azure SQL DB. vCore based is the recommended purchasing model with a vCore representing a logical CPU. vCore based is available for both Azure SQL DB and Azure SQL MI. You can choose the hardware you require, tailoring vCore's memory and storage capacity to the needs of your workload. Switching to the portal, I'm going to create a database for a logical SQL DB server that has already been created. Picking the resource group that has the logical server within it, I'll scroll down and enter a database name, which must be unique (keyboard clicks) and pick the server if it hasn't been selected already. And this is the one that I…
Contents
-
-
-
-
-
Introduction to Azure SQL DB and Azure SQL Managed Instance (MI)4m 38s
-
(Locked)
Purchasing models for Azure SQL DB and SQL MI5m 45s
-
(Locked)
Azure SQL DB and SQL MI service tiers5m 15s
-
(Locked)
Managing pre-provisioned compute for Azure SQL DB and SQL MI9m 8s
-
(Locked)
Serverless and Hyperscale compute tier for Azure SQL DB4m 27s
-
(Locked)
Scaling options for Azure SQL DB and SQL MI5m 47s
-
(Locked)
Encryption at rest and in transit on Azure SQL DB and SQL MI6m 43s
-
(Locked)
Always Encrypted for Azure SQL DB and SQL MI6m 59s
-
(Locked)
Dynamic data masking for Azure SQL DB and SQL MI4m 59s
-
(Locked)
Data discovery, classification, and audit for Azure SQL DB and SQL MI6m 8s
-
(Locked)
High availability and business continuity for Azure SQL DB and SQL MI10m
-
(Locked)
Performance monitoring and tuning for Azure SQL DB and SQL MI5m 11s
-
(Locked)
IaaS for relational data with Azure SQL VM7m 23s
-
(Locked)
Azure SQL VM Agent for SQL on Azure VMs5m 53s
-
(Locked)
Azure SQL at the edge2m 45s
-
-
-
-