本文介绍了SQL 2005事务复制关键性能的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

有点奇怪,我不明白.

我们有一个事务性出版物,它在Replication Monitor中不断出现关键"性能.但是,这是个用过的表,当您在订阅监视列表"选项卡上查看详细信息时,它显示没有未分配的命令.在发布者到分发历史"或分发者到订阅历史"中没有消息.

我什至重新初始化了快照.因此,据我所知,应该没有理由认为这是至关重要的性能.

有人可以建议其他地方看看吗?

谢谢

Got a bit of an odd one, that I don''t understand.

We have a transactional publication that keeps popping up with "critical" performance in Replication Monitor. However, it''s a little used table, and when you view the details on the "Subscription Watch List" tab, it shows there''s no undistributed commands. There''s no messages in the "Publisher to Distribution History" or "Distributor To Subscriber History".

I''ve even reinitialised the snapshot. So as far as I can tell, there should be no reason this should pop up as being critical performance.

Can anybody suggest other places to look?

Thanks

推荐答案


这篇关于SQL 2005事务复制关键性能的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

10-19 22:12