Bacpac的进口相当缓慢 [英] Import of Bacpac considerably slow
问题描述
使用流利的MgmtApis。我可以吗运行安装了sqlpackage的ACI?如果是这样,我如何开始并等待ACI中容器的执行
来自持久的 zure函数?
感谢您的帮助,
Florian
嗨Florian,
当许多客户在同一地区同时发出导入或导出请求时,会出现此问题。 Azure SQL数据库导入/导出服务为每个区域提供有限的
数量的计算虚拟机(VM),以处理导入和导出操作。每个区域都托管Compute VM,以确保导入或导出避免跨区域带宽延迟和收费。如果在同一地区同时以
提出的请求太多,则在处理操作时会出现严重延迟。完成请求所需的时间可能从几秒到几小时不等。
有关详细信息,请参阅" Azure SQL数据库
导入/导出服务需要很长时间才能导入或导出数据库"。
< span style ="font-size:10.0pt; line-height:107%; font-family:'Verdana',sans-serif">而且,我建议你投票给另一位Azure客户提交的想法。
您在这些论坛中分享的所有反馈都将由负责构建Azure的Microsoft工程团队进行监控和审核。
Hi,
import of bacpac to sqlazure db (bacpac size ~800mb) using C# fluent MgmtAPI libs or via portal takes around 15 mins. Any ideas on how to speed things up? I'm on durable azure functions using fluent MgmtApis. Can I e.g. run a ACI with sqlpackage installed? If so, how can I start and await execution of a container in ACI from durable azure functions?
Thanks for your help,
Florian
Hi Florian,
This problem occurs when many customers make an import or export request at the same time in the same region. The Azure SQL Database Import/Export Service provides a limited number of Compute virtual machines (VMs) per region to process the import and export operations. The Compute VM is hosted per region to make sure that the import or export avoids cross-region bandwidth delays and charges. If too many requests are made at the same time in the same region, significant delays occur in processing the operations. The time that is required to complete requests can vary from a few seconds to many hours.
For more details, refer "Azure SQL Database Import/Export Service takes a long time to import or export a database".
And also, I would suggest you to vote up an idea submitted by another Azure customer.
All of the feedback you share in these forums will be monitored and reviewed by the Microsoft engineering teams responsible for building Azure.
这篇关于Bacpac的进口相当缓慢的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!