I believe I’m having performance issues with my merge replication setup.
The reason I believe I’m having trouble is because the progress bar shown in the details window of the subscription, shown in replication monitor, doesn’t get up to 100% for download/upload completion, in fact it usually slowly goes down
while the approximate time remaining goes up. When I look at the Synchronization Status on the subscriber, the blue bar underneath the “Last Status Message” doesn’t go the whole way across.
When I validate the subscription, validation fails for a number of tables but that is what I expect to happen because in order to validate, I need to stop the subscription from continuously updating so I can restart the synchronization in order to get the
Here is my setup: Server A has 2 quad core Intel (X5460) 3.16GHz CPUs, 32 GB of RAM and a Gigabit Ethernet card.
Server B has 2 quad core Intel (E5530) 2.40GHz CPUs, 24 GB of RAM and a Gigabit Ethernet card with a Gigabit switch between the two servers.
The merge agent profile is using the “High Volume Server-to-Server Profile”.
I am trying to get one publication from server A to server B using a pull subscription which is polling every second.
View Complete Post