Database paused cost

Question

Hello,

If the database in paused condition, the database still consume cost or not?

Answer 1

Hi,

When Azure SQL Database serverless is paused there is no cost for Compute, however, you still have to pay for storage. Please see article below:

Serverless compute tier for Azure SQL Database - Cost

https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql&tabs=general-purpose#cost

Thanks.

-TP

Answer 2

Hi Handian Sudianto •,

Welcome to Microsoft Q&A forum.

In addition to above answer, you may refer to plan and manage costs of Azure SQL Database which could help in monitoring the same.

In the vCore purchasing model, Azure SQL Database also supports two types of compute tiers: provisioned throughput and serverless. The way you get charged for each compute tier varies so it's important to understand what works best for your workload when planning and considering costs. For details, see vCore model overview - compute tiers.

In the provisioned compute tier of the vCore-based purchasing model, you can exchange your existing licenses for discounted rates. For details, see Azure Hybrid Benefit (AHB).

For environments with multiple databases that have varying and unpredictable usage demands, elastic pools can provide cost savings compared to provisioning the same number of single databases. For details, see Elastic pools.

Use the Azure pricing calculator to estimate costs for different Azure SQL Database configurations. For more information, see Azure SQL Database pricing.

Azure SQL Database runs on Azure infrastructure that accrues costs along with Azure SQL Database when you deploy the new resource. It's important to understand that additional infrastructure might accrue cost.

Azure SQL Database (except for serverless) is billed on a predictable, hourly rate. If the SQL database is active for less than one hour, you are billed for the highest service tier selected, provisioned storage, and IO that applied during that hour, regardless of usage or whether the database was active for less than an hour.

Billing depends on the SKU of your product, the generation hardware of your SKU, and the meter category. Azure SQL Database has the following possible SKUs:

• Basic (B)
• Standard (S)
• Premium (P)
• General Purpose (GP)
• Business Critical (BC)
• And for storage: geo-redundant storage (GRS), locally redundant storage (LRS), and zone-redundant storage (ZRS)
• It's also possible to have a deprecated SKU from deprecated resource offerings

Refer https://learn.microsoft.com/en-us/azure/azure-sql/database/cost-management?view=azuresql for more details.

Thanks for visiting Microsoft Q&A forum.