数据同步异常缓慢（或被卡住） [英] Datasync anormaly slow (or stucked)
问题描述
您好，
我正在尝试Datasync的问题，同步需要花费很多时间或者被卡住，我等待，当我点击更新按钮查看是否一些日志消息显示...每隔10或15分钟显示一条消息：
250083行中的27783行然后
34500在3600s左右
43317行在4500s左右b
51763行在5400s左右
6300s中的60498行
86862行9000s等...我停止de syncro，因为它看起来不正常同步。
我使用免费azure的试用版（有效期为一个月，170欧元学分）
我正在执行一些测试同步一个本地数据库和一个HUB数据库，本地数据库是一个我在stackOverflow网站（10gb版本）下载。
我同步只有一个表 称为"徽章" ，该表有1 102 019行
第一次同步大约需要5分钟。
然后我在原点插入50 000行，然后点击同步按钮
同步时需要大约1mn和30秒。
然后我删除原始和脉冲同步中的那50 000行...这是当问题发生时...这看起来不正常，但我不知道如何解决它。
我执行了一个我在MS网站上找到的powershell脚本，但它只是告诉我一切正常...
这个问题几天前就已经开始了，之前我可以用这些时间再运行一些同步：
删除50000行：2：50
插入100 000行：3：00
更新100 000行：6：00
插入500 000行：15mn
但现在我得到了一条奇怪的信息：在10分钟内处理了10 000行或类似的事情。
让它再次运行的唯一方法是删除中心数据库（无需触摸）使用syncDB和代理）并重新配置数据同步。然后我可以执行第一次同步，也许还可以再执行一次，但问题再次发生...
我也尝试删除包括内部数据库在内的所有内容，以一些新的内容开始，但它没有解决问题。
我没有使用Azure的经验，也没有在互联网上找到类似的问题...
if有人想知道在哪里搜索...
我可以根据需要发送更多信息
谢谢
Hi Thibaut，
存在涵盖 监视器和
疑难解答 Azure数据同步。监视器选项使您能够使用Azure门户记录传统上必须研究的所有问题。它提供了一种更先进的方法来捕获问题并对其进行故障排除。故障排除文档涵盖了
特定的故障排除方案。
您是否有足够的存储和计算可用于在给定数据量等情况下完成同步？这是一般性问题。
问候，
迈克
Hello,
I'm experimenting problems with Datasync, the syncronization takes a lot of time or is stucked, i wait and when i click the update button to see if some log message shows... every 10 or 15 minutes it shows a message like :
25783 rows in 2700s then
34567 in 3600s
43317 rows in 4500s
51763 rows in 5400s
60498 rows in 6300s
86862 rows in 9000s etc... i stop de syncro since it doesn't look a normal syncronization.
i use a free trial veriosn of azure (valid one month with 170 euros credits)
i'm performing some testing syncronizing an on-premises DB and a HUB database, the on-premises DB is one i downloaded in stackOverflow website (the 10gb version).
i syncronize only one table called "badges" , the table has 1 102 019 rows
the first syncronization takes about 5 minutes.
then i insert 50 000 rows in origin , and click the syncronize button
it takes about 1mn and 30seconds to syncronize.
then i delete those 50 000 rows in origin and pulse syncro... this is when the problem occurs... this doesn't looks normal but i don't know how to troubleshoot it.
i executed a powershell script i found on MS site but it just tells me everything is ok ...
This problem started occuring a few days ago, before i could run some more syncronizations with these times:
delete 50000 rows: 2:50
insert 100 000 rows: 3:00
update 100 000 rows: 6:00
insert 500 000 rows: 15mn
but now i get that strange message : 10 000 rows processed in 10minutes or something similar.
the only way to get it work again is delete the hub database (without touching the syncDB and agent) and reconfigure datasync. then i can perform the first sync and maybe one more but then the problems occurs again...
i also tried deleting everything including the on premise db to start with somethng new but it doesn't solve the problem.
i have no experience with Azure, and haven't found similar issues on the internet...
if someone had some ideas where to search...
i can send more info if needed
thank you
Hi Thibaut,
There exists documentation covering monitor and troubleshoot Azure Data Sync. The monitor options gives you a means to log all the issues you traditionally had to research using the Azure Portal. It provides a more advanced means to capture and then troubleshoot the issue. The troubleshoot doc covers specific scenarios to troubleshoot.
Do you have sufficient storage and compute available to complete the sync given the volume of data, etc.? This is a general question.
Regards,
Mike
这篇关于数据同步异常缓慢（或被卡住）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
