Azure SQL: What is the cost of running a specific

2019-08-29 04:47发布

问题:

What are the costs of running the following operation in Azure?

drop database MyDB;
create database MyDB as copy of MyDB_Clean;

The scope of the above operation is to restore an existing database to its clean version to improve web site performance.

It will run once every day via an Azure web job and would like to assess if this would be feasible in terms of costs.

MyDB_Clean used space = 35 MB, allocated space 48 MB, using Tiers S0/S1/S2

回答1:

What are the costs of running the following operation in Azure?

Just the cost for the two databases, and if they fit in a single Elastic Pool, there would be no additional cost. See the Pricing Page for the different pricing models.