Slow Replication Monitor (SQL 2005)

[Andel]

In replication monitor, when I expand a Publisher to see my publications, it will take too much time to expand. The monitor shows "<MYSQLSERVER> (expanding...)" for a long time then eventually expands. Is there any setting for this to make it faster?

 

[mrdenny]

How many publications do you have on that Publisher? How many subscribers are you dealing with? Is the distributor busy?

If you have a lot of replication going on then you may have problems like these in the manager. It's normal as blocking is going on while the subscribers check in.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[Andel]

On one publisher, there are 4 publications. I have 6 subscribers. I have a dedicated distributor. It is hosting quite a few publishers. So it is busy Do you know any settings or tricks to make the monitor act faster?

 

[mrdenny]

Nope, not really. Check the system and you'll probably see that the slow down is caused by blocking, in which case you'll want to see why the commands which are causing the blocking are running so slow.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog