Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Merge replication 2005

Posted on 2007-11-21
15
Medium Priority
?
464 Views
Last Modified: 2008-09-20
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
0
Comment
Question by:Richardsoet
[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
 

Author Comment

by:Richardsoet
ID: 20328976
Do you think  -ParallelUploadDownload would help .if yes how do i set that  in sql2005
run through the step for me
0
 

Author Comment

by:Richardsoet
ID: 20329473
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
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20330756
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 ...
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 

Author Comment

by:Richardsoet
ID: 20333835
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
0
 
LVL 18

Accepted Solution

by:
Yveau earned 1000 total points
ID: 20336095
... 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 ...
0
 

Author Comment

by:Richardsoet
ID: 20337666


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
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20338242
Run the Replication Monitor and see if you can track down the problem area.
I need more detailed info to help you any further.
0
 

Author Comment

by:Richardsoet
ID: 20340712
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
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20346310
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.
0
 

Author Comment

by:Richardsoet
ID: 20346321
The sync is taken a minutes? Any way out to improve it ? please lay down the steps to follow
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20346349
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 ...
0
 

Author Comment

by:Richardsoet
ID: 20348821
what should the network traffic be for merge replication? Any idea what is the best pratice for the network
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20351651
Only a few packages should be send over, depending on the SQL code.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question