Azure SQL：运行特定的SQL查询（如创建数据库作为副本）的成本是多少 [英] Azure SQL: What is the cost of running a specific SQL query like create database as copy

问题描述

在Azure中运行以下操作的成本是多少？

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.

它将每天通过Azure Web作业运行一次，并希望从成本方面评估这是否可行。

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 已用空间= 35 MB，已分配空间48 MB，使用层S0 / S1 / S2

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

推荐答案

在Azure中运行以下操作的成本是多少？

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.

这篇关于Azure SQL：运行特定的SQL查询（如创建数据库作为副本）的成本是多少的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！