Azure sqldatabase还是虚拟专用服务器?

发布于 2025-02-10 05:58:20 字数 373 浏览 2 评论 0原文

我是Azure的新手,目前正在探索将数据库从虚拟专用服务器迁移到Azure托管SQL数据库的可能性。我可以看到转向Azure,减少维护,托管云,更便宜的潜在优势。

我的VPS目前每月支付36英镑,这是一笔固定付款。但是,在使用定价计算器的Azure上,我可以看到,使用标准层的价格约为14英镑,这是一个巨大的节省。我唯一的问题是我选择了DTU。现在,我担心一个月可能会很好,但是又一个月的费用可能会飙升。我之所以犹豫要迁移的原因是因为我每月支付36英镑都可以知道我可以使用少或更多,而且我仍然会以固定的费用。

另一方面 - 使用DTU使用Azure,不能保证我每月可能会有相同的费用,它可能会更高。

我的问题是有人可以为我解释DTU,还有一种方法可以确保我的成本较低而将来没有任何意外费用?

I am new to Azure and I am currently exploring the possibility of migrating my database from a Virtual private server to an Azure hosted sql database. I can see the potential advantage of moving to azure, less maintenance, cloud hosted, cheaper.

My VPS i currently pay £36 every month, this is a fixed payment. However on Azure using the pricing calculator i can see that with a standard tier it would cost about £14, which is a huge saving. My only issue is that I have chosen the DTU. Now i am worried that for one month it may be fine, but for another month cost may spike. The reason why I have been hesitant to migrate is because I am fine with paying £36 a month knowing i can use less or more and i will still be at a fixed cost.

On the other hand - using azure with dtu, there is no guarantee that i may have the same cost each month, it may be potentially higher.

My question is can someone explain DTU for me and also is there a way where i can make sure my cost is low without having any surprise costs in the future?

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(1

伴梦长久 2025-02-17 05:58:20

在基于DTU的SQL购买模型中,通过性能层分配了一组固定的资源或弹性池:基本,标准和高级。该模型最适合每个月固定付款的简单性的客户,其中需要预先配置的选项的简单性。

您需要首先测量资源利用以检查现在很多DTU对您来说足够了。

测量以下利用率指标至少一个小时,以便计算器可以随着时间的推移分析利用率,以为您提供最佳建议:

  • 处理器 - %处理器时间
  • 逻辑磁盘 - 磁盘读取/sec
  • 逻辑磁盘 - 磁盘writes/sec
  • 数据库 - log bytes flushed/flushed flushed flushed flushed/ sec

参考此文档以计算数据库资源消耗。获得输出后,计算按钮以在同一页面上查看建议的服务层/性能级别,并在同一页面上查看DTU。

您的消耗成本将如下图所示:

”在此处输入图像描述

您也可以根据计算的DTU 在这里

In DTU-based SQL purchase models, a fixed set of resources is assigned to the database or elastic pool via performance tiers: Basic, Standard and Premium. This model is best for customers who prefer the simplicity of fixed payments each month, where the simplicity of pre-configured options is desired.

You need to first measure the resource utilization to check now much DTU is enough for you.

Measure the following utilization metrics for at least an hour so the calculator can analyze utilization over time to provide you the best recommendation:

  • Processor - % Processor Time
  • Logical Disk - Disk Reads/sec
  • Logical Disk - Disk Writes/sec
  • Database - Log Bytes Flushed/sec

Refer this document to calculate the database resource consumption. Once you will get the output, calculate button to view your recommended Service Tier/Performance Level and DTUs on the same page.

Your consumption cost will be as per given image below:

enter image description here

You can also check your the pricing based on the your calculated DTUs here.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文