To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.
Course Of The Month
2 days, 19 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Merge replication 2005
Posted on 2007-11-21
I tried to update one record from publisher and it's taking 1min for the changes to get updated on the subscriber .
Any reason why ?
How do i resolve the problem
Am on SQL 2005 Merge replication
Any reason why ?
How do i resolve the problem
Am on SQL 2005 Merge replication
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
7
6
15 Comments
Do you think -ParallelUploadDownload would help .if yes how do i set that in sql2005
run through the step for me
run through the step for me
how do i set -ParallelUploadDownload for merge replication on sql 2005 to allow agent to process the changes uploaded to the Publisher and those downloaded to the Subscriber at the same time
Try this site for more info:
http://msdn2.microsoft.com/en-us/library/ms152531.aspx
or specific for the sync process:
http://msdn2.microsoft.com/en-us/library/ms151793.aspx
or on the ParallelUploadDownload option:
http://msdn2.microsoft.com/en-us/library/ms147886.aspx
Hope this helps ...
http://msdn2.microsoft.com/en-us/library/ms152531.aspx
or specific for the sync process:
http://msdn2.microsoft.com/en-us/library/ms151793.aspx
or on the ParallelUploadDownload option:
http://msdn2.microsoft.com/en-us/library/ms147886.aspx
Hope this helps ...
Thanks for the link but that does not seems to solve my problem.
I have set ParallelUploadDownload to 1 but that does not seem to work.
my problem is when i tried to update one record from publisher and it's taking 1min for the changes to get updated on the subscriber .
The table is got 300000 rows and its indexed.and the row guid on the table is indexed as well.\\Any way to retrieve faster than a minute please explain the method to attain this
I have set ParallelUploadDownload to 1 but that does not seem to work.
my problem is when i tried to update one record from publisher and it's taking 1min for the changes to get updated on the subscriber .
The table is got 300000 rows and its indexed.and the row guid on the table is indexed as well.\\Any way to retrieve faster than a minute please explain the method to attain this
... is the mirroring take a minute, or is the mirror job only running once a minute ? It should be running continuously.
... what about the network latency. I tested mirroring in my testlab and a certain scenario run in a few seconds. When I set it up with my colleague across the Pacific, it ran for almost 45 minutes ... all due to the network.
One record should be done in a blink of a eye. If the two machine are standing 'next to each other' and the job runs continuously ...
Hope this helps ...
... what about the network latency. I tested mirroring in my testlab and a certain scenario run in a few seconds. When I set it up with my colleague across the Pacific, it ran for almost 45 minutes ... all due to the network.
One record should be done in a blink of a eye. If the two machine are standing 'next to each other' and the job runs continuously ...
Hope this helps ...
Please help it is set to run continuosly on the same network and when I do an update of a record with a where clause it takes a miutes to synch through to the subsriber from the publisher.The table is indexed .Please help what can I do to improve it.am running on SQL 2005 merge replication
Run the Replication Monitor and see if you can track down the problem area.
I need more detailed info to help you any further.
I need more detailed info to help you any further.
What sort of info do you need in Repl monitor , there is no confilit , one update was done on one table ,download was done then sync but it takes 1 min before showing on subscriber
Keep refreshing it during the minute it takes to sync and see if there is any activity. The stats should make it clear whether the replication is waiting for a minute to start syncing, or the syncing is just taking a minute.
it has to be something with the network ... let your network guys help you check out the network traffic when doing a sync. Maybe someone can run WireShark for you ... don;t try it yourself it's a network sniffer, that kind of software can get you into big problems with the network guys !
Hope this helps ...
Hope this helps ...
what should the network traffic be for merge replication? Any idea what is the best pratice for the network
Featured Post
PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3.
When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
This article explains how to reset the password of the sa account on a Microsoft SQL Server. The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash"
After Shake : http://www.videocopilot.net/presets/after_shake/
All lightning effects with instructions : http://www.mediaf…
Suggested Courses
Course of the Month2 days, 19 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
696 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.