如何为Azure数据库选择适当的计划 [英] How to select appropriate plan for the Azure Database

问题描述

 在我的项目中，我们使用的是Mcirosoft Azure SQl DB.

  In my project, we are using Mcirosoft Azure SQl DB.

数据库很小，只有3个表.

The database is small with just 3 tables.

在对40个并发用户进行负载测试期间(每个事务执行4个sql查询(插入+选择))，我们得到了很高的响应时间.

During load testing with 40 concurrent users (each transaction doing 4 sql queries (insert + select), we are receiving high respone times.

平均响应时间交易大约需要5秒钟.

The average response time  for the transaction is around 5 seconds.

我们验证了索引是好的.

We verified indexes are good.

当前，我们正在使用标准的S2计划(50 DTU).

currently we are using standard S2 plan (50 DTU).

您能帮我确定我的企业数据库所需的最大DTU的方法吗?

Can you please help me with the method i can use to identify the max DTU that my enterprise DB needs ?

感谢&问候

拉耶夫·纳瓦亚特

推荐答案

Rajeev，您好，

Hi Rajeev,

您可能想利用Intelligent Insights来确定最佳配置.有关详细信息，请参阅 https://docs.microsoft.com/zh-cn/azure/sql-database/sql-database-intelligent-insights-troubleshoot-performance

you might want to take advantage of Intelligent Insights to identify the optimal configuration. For details, refer to https://docs.microsoft.com/en-us/azure/sql-database/sql-database-intelligent-insights-troubleshoot-performance

hth
Marcin

hth
Marcin

这篇关于如何为Azure数据库选择适当的计划的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！