You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Copy file name to clipboardExpand all lines: azure-sql/database/cost-management.md
+3-1Lines changed: 3 additions & 1 deletion
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -6,6 +6,7 @@ ms.author: kendralittle
6
6
ms.custom: subject-cost-optimization
7
7
ms.service: sql-database
8
8
ms.subservice: service-overview
9
+
ms.reviewer: mathoma
9
10
ms.topic: how-to
10
11
ms.date: 06/30/2021
11
12
---
@@ -70,7 +71,8 @@ Billing depends on the SKU of your product, the generation hardware of your SKU,
70
71
- And for storage: geo-redundant storage (GRS), locally redundant storage (LRS), and zone-redundant storage (ZRS)
71
72
- It's also possible to have a deprecated SKU from deprecated resource offerings
72
73
73
-
For more information, see [purchasing models](purchasing-models.md). For more information on service tiers, see [DTU service tiers](service-tiers-dtu.md#compare-service-tiers) and [vCore service tiers](service-tiers-sql-database-vcore.md#service-tiers).
74
+
For more information, see [vCore-based purchasing model](service-tiers-vcore.md), [DTU-based purchasing model](service-tiers-dtu.md), or [compare purchasing models](purchasing-models.md).
75
+
74
76
75
77
The following table shows the most common billing meters and their possible SKUs for **single databases**:
Copy file name to clipboardExpand all lines: azure-sql/database/high-cpu-diagnose-troubleshoot.md
+3-3Lines changed: 3 additions & 3 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -29,7 +29,7 @@ You can quickly identify the vCore count for a database in the Azure portal if y
29
29
30
30
For databases in the [serverless](serverless-tier-overview.md) compute tier, vCore count will always be equivalent to the max vCore setting for the database. VCore count will show in the **pricing tier** listed for the database on its **Overview** page. For example, a database's pricing tier might be 'General Purpose: Serverless, Gen5, 16 vCores'.
31
31
32
-
If you're using a database under the [DTU-based purchase model](service-tiers-dtu.md), you will need to use Transact-SQL to query the database's vCore count.
32
+
If you're using a database under the [DTU-based purchasing model](service-tiers-dtu.md), you will need to use Transact-SQL to query the database's vCore count.
33
33
34
34
### Identify vCore count with Transact-SQL
35
35
@@ -374,9 +374,9 @@ Consider experimenting with small changes in the MAXDOP configuration at the dat
374
374
375
375
You may find that your workload's queries and indexes are properly tuned, or that performance tuning requires changes that you cannot make in the short term due to internal processes or other reasons. Adding more CPU resources may be beneficial for these databases. You can [scale database resources with minimal downtime](scale-resources.md).
376
376
377
-
You can add more CPU resources to your Azure SQL Database by configuring the vCore count or the [hardware generation](service-tiers-sql-database-vcore.md#hardware-generations) for databases using the [vCore purchase model](service-tiers-sql-database-vcore.md).
377
+
You can add more CPU resources to your Azure SQL Database by configuring the vCore count or the [hardware generation](service-tiers-sql-database-vcore.md#hardware-generations) for databases using the [vCore purchasing model](service-tiers-sql-database-vcore.md).
378
378
379
-
Under the [DTU-based purchase model](service-tiers-dtu.md), you can raise your service tier and increase the number of database transaction units (DTUs). A DTU represents a blended measure of CPU, memory, reads, and writes. One benefit of the vCore purchase model is that it allows more granular control over the hardware in use and the number of vCores. You can [migrate Azure SQL Database from the DTU-based model to the vCore-based model](migrate-dtu-to-vcore.md) to transition between purchase models.
379
+
Under the [DTU-based purchasing model](service-tiers-dtu.md), you can raise your service tier and increase the number of database transaction units (DTUs). A DTU represents a blended measure of CPU, memory, reads, and writes. One benefit of the vCore purchasing model is that it allows more granular control over the hardware in use and the number of vCores. You can [migrate Azure SQL Database from the DTU-based model to the vCore-based model](migrate-dtu-to-vcore.md) to transition between purchasing models.
Azure SQL Database lets you easily purchase a fully managed platform as a service (PaaS) database engine that fits your performance and cost needs. Depending on the deployment model you've chosen for Azure SQL Database, you can select the purchasing model that works for you:
20
20
21
-
-[Virtual core (vCore)-based purchasing model](service-tiers-sql-database-vcore.md) (recommended). This purchasing model provides a choice between a provisioned compute tier and a serverless compute tier. With the provisioned compute tier, you choose the exact amount of compute resources that are always provisioned for your workload. With the serverless compute tier, you specify the autoscaling of the compute resources over a configurable compute range. The serverless compute tier automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns. The vCore unit price per unit of time is lower in the provisioned compute tier than it is in the serverless compute tier. The [Hyperscale service tier](service-tier-hyperscale.md) is available for single databases that are using the [vCore-based purchasing model](service-tiers-vcore.md).
21
+
-[Virtual core (vCore)-based purchasing model](service-tiers-sql-database-vcore.md) (recommended). This purchasing model provides a choice between a provisioned compute tier and a serverless compute tier. With the provisioned compute tier, you choose the exact amount of compute resources that are always provisioned for your workload. With the serverless compute tier, you specify the autoscaling of the compute resources over a configurable compute range. The serverless compute tier automatically pauses databases during inactive periods when only storage is billed and automatically resumes databases when activity returns. The vCore unit price per unit of time is lower in the provisioned compute tier than it is in the serverless compute tier. The [hyperscale service tier](service-tier-hyperscale.md) is available for single databases that are using the [vCore-based purchasing model](service-tiers-vcore.md).
22
22
-[Database transaction unit (DTU)-based purchasing model](service-tiers-dtu.md). This purchasing model provides bundled compute and storage packages balanced for common workloads.
23
23
24
24
## vCore purchasing model
25
+
25
26
There are two purchasing models:
26
27
27
-
-[vCore-based purchasing model](service-tiers-vcore.md) is available for both [Azure SQL Database](sql-database-paas-overview.md) and [Azure SQL Managed Instance](../managed-instance/sql-managed-instance-paas-overview.md). The [Hyperscale service tier](service-tier-hyperscale.md) is available for single databases that are using the [vCore-based purchasing model](service-tiers-vcore.md).
28
+
-[vCore-based purchasing model](service-tiers-vcore.md) is available for both [Azure SQL Database](sql-database-paas-overview.md) and [Azure SQL Managed Instance](../managed-instance/sql-managed-instance-paas-overview.md). The [hyperscale service tier](service-tier-hyperscale.md) is available for single databases that are using the [vCore-based purchasing model](service-tiers-vcore.md).
28
29
-[DTU-based purchasing model](service-tiers-dtu.md) is available for [Azure SQL Database](single-database-manage.md).
29
30
30
31
The following table and chart compare and contrast the vCore-based and the DTU-based purchasing models:
@@ -37,10 +38,6 @@ The following table and chart compare and contrast the vCore-based and the DTU-b
37
38
38
39

@@ -67,16 +64,16 @@ For more information about storage prices, see the [pricing](https://azure.micro
67
64
68
65
A virtual core (vCore) represents a logical CPU and offers you the option to choose between generations of hardware and the physical characteristics of the hardware (for example, the number of cores, the memory, and the storage size). The vCore-based purchasing model gives you flexibility, control, transparency of individual resource consumption, and a straightforward way to translate on-premises workload requirements to the cloud. This model allows you to choose compute, memory, and storage resources based on your workload needs.
69
66
70
-
In the vCore-based purchasing model for SQL Database, you can choose between the general purpose and business critical service tiers. Review [service tiers](service-tiers-sql-database-vcore.md#service-tiers) to learn more. For single databases, you can also choose the [Hyperscale service tier](service-tier-hyperscale.md).
67
+
In the vCore-based purchasing model for SQL Database, you can choose between the general purpose and business critical service tiers. Review [service tiers](service-tiers-sql-database-vcore.md#service-tiers) to learn more. For single databases, you can also choose the [hyperscale service tier](service-tier-hyperscale.md).
71
68
72
69
The vCore-based purchasing model lets you independently choose compute and storage resources, match on-premises performance, and optimize price. In the vCore-based purchasing model, you pay for:
73
70
74
71
- Compute resources (the service tier + the number of vCores and the amount of memory + the generation of hardware).
75
72
- The type and amount of data and log storage.
76
-
- Backup storage (RA-GRS).
73
+
- Backup storage.
77
74
78
75
> [!IMPORTANT]
79
-
> Compute resources, I/O, and data and log storage are charged per database or elastic pool. Backup storage is charged per each database.
76
+
> For single databases, compute resources, I/O, and data and log storage are charged per database. For elastic pools, these resources are charged per pool. However, backup storage is always charged per database.
Copy file name to clipboardExpand all lines: azure-sql/database/resource-limits-logical-server.md
+9-5Lines changed: 9 additions & 5 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -10,7 +10,7 @@ ms.topic: reference
10
10
author: dimitri-furman
11
11
ms.author: dfurman
12
12
ms.reviewer: kendralittle, mathoma
13
-
ms.date: 10/01/2021
13
+
ms.date: 01/20/2022
14
14
---
15
15
16
16
# Resource management in Azure SQL Database
@@ -167,7 +167,7 @@ Log rate governor traffic shaping is surfaced via the following wait types (expo
167
167
168
168
When encountering a log rate limit that is hampering desired scalability, consider the following options:
169
169
170
-
- Scale up to a higher service level in order to get the maximum log rate of a service tier, or switch to a different service tier. The [Hyperscale](service-tier-hyperscale.md) service tier provides 100 MB/s log rate regardless of chosen service level.
170
+
- Scale up to a higher service level in order to get the maximum log rate of a service tier, or switch to a different service tier. The [hyperscale](service-tier-hyperscale.md) service tier provides 100 MB/s log rate regardless of chosen service level.
171
171
- If data being loaded is transient, such as staging data in an ETL process, it can be loaded into tempdb (which is minimally logged).
172
172
- For analytic scenarios, load into a clustered [columnstore](/sql/relational-databases/indexes/columnstore-indexes-overview) table, or a table with indexes that use [data compression](/sql/relational-databases/data-compression/data-compression). This reduces the required log rate. This technique does increase CPU utilization and is only applicable to data sets that benefit from clustered columnstore indexes or data compression.
173
173
@@ -206,14 +206,18 @@ This move occurs in an online fashion, similarly to a database scaling operation
206
206
Because all data is copied to local storage volumes on different machines, moving larger databases may require a substantial amount of time. During that time, if local space consumption by the database or elastic pool, or by the tempdb database grows rapidly, the risk of running out of space increases. The system initiates database movement in a balanced fashion to minimize out-of-space errors while avoiding unnecessary failovers.
207
207
208
208
> [!NOTE]
209
-
> Database movement due to insufficient local storage only occurs in the Premium or Business Critical service tiers. It does not occur in the Hyperscale, General Purpose, Standard, and Basic service tiers, because in those tiers data files are not stored in local storage.
209
+
> Database movement due to insufficient local storage only occurs in the Premium or Business Critical service tiers. It does not occur in the hyperscale, General Purpose, Standard, and Basic service tiers, because in those tiers data files are not stored in local storage.
210
210
211
211
## Tempdb sizes
212
212
213
-
Size limits for tempdb in Azure SQL Database depend on the purchasing and deployment model. To learn more, review tempdb size limits for [vCore](resource-limits-vcore-single-databases.md), [single databases (DTU)](resource-limits-dtu-single-databases.md#tempdb-sizes), [pooled databases (DTU)](resource-limits-dtu-elastic-pools.md#tempdb-sizes).
213
+
Size limits for tempdb in Azure SQL Database depend on the purchasing and deployment model.
- For information about general Azure limits, see [Azure subscription and service limits, quotas, and constraints](../../azure-resource-manager/management/azure-subscription-service-limits.md).
218
222
- For information about DTUs and eDTUs, see [DTUs and eDTUs](purchasing-models.md#dtu-purchasing-model).
219
-
- For information about tempdb size limits, see [vCore](resource-limits-vcore-single-databases.md), [single databases (DTU)](resource-limits-dtu-single-databases.md#tempdb-sizes), [pooled databases (DTU)](resource-limits-dtu-elastic-pools.md#tempdb-sizes).
223
+
- For information about tempdb size limits, see [single vCore databases](resource-limits-vcore-single-databases.md), [pooled vCore databases](resource-limits-vcore-elastic-pools.md), [single DTU databases](resource-limits-dtu-single-databases.md#tempdb-sizes), and [pooled DTU databases](resource-limits-dtu-elastic-pools.md#tempdb-sizes).
0 commit comments