question

RavindraJoshi-0203 avatar image
0 Votes"
RavindraJoshi-0203 asked AlbertoMorillo edited

If I stop the database will it cost me in Azure?

If I stop the database will it cost me in Azure?

azure-sql-database
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Which type of Azure SQL DB are you talking about? Can you share link to particular document if you are referring any. In general, we can't stop Azure SQL Databases.

1 Vote 1 ·

It was a question in AZ 900 exam.

0 Votes 0 ·

Hi @RavindraJoshi-0203, just wanted to check if you need any other details. If answer helped, you can mark it 'Accept Answer'

0 Votes 0 ·
VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered

We can't stop the Azure SQL DB to save the cost at this moment.

But there are other services where, for sure, you save the cost when the service is paused or stopped.. Say, pausing Synapse SQL pool, stopping virtual machine, pausing Kusto cluster etc.


Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AlbertoMorillo avatar image
1 Vote"
AlbertoMorillo answered AlbertoMorillo edited

The only Azure SQL Database product (PaaS) that can be stopped is Azure SQL Serverless. It can be configured to auto-pause when it has an specific number of hours without activity. You can configure that using control panel as shown below:

122115-image.png

The minimum time you can specify for auto-pause is 1 hour. However even when its computing power can be paused, you still continue to pay for the storage the database is consuming. On the Cost section of this article you will find the following excerpt:

"When the database is paused, the compute cost is zero and only storage costs are incurred."

You can learn more about how to auto-pause a database on this documentation,





image.png (17.2 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.