Merge Replication - Fast Sync
- From: "savvaschr@xxxxxxxxxxxxxxxx" <savvaschr@xxxxxxxxxxxxxxxx>
- Date: 22 Dec 2006 05:57:13 -0800
Hello ,
I have a database in SQL2005 is adatabase of 52 tables and is Merge
Replicated.
Currently 12 Handhelds use this set ... but in the futere we will go up
to 60 handhelds.
Depending from the changes, Synchronization (Using GPRS) is taking now
on average 1 or 2 minutes or sometimes 4-5 minutes. Some other times i
get complains that "It took 10 minutes yestarday to Sync" Or
"It took 40 Minutes to Sync" but in a month that happend 2 or 3 times.
Now my Question is , How can i Maintain this speed od Sync (1-4
minutes) when all 60 handhelds will go live?
(Must I run The Snapshot Agent frequently?And if yes How Frequent?)
Thanks
Savvas Christodoulou
.
- Follow-Ups:
- Re: Merge Replication - Fast Sync
- From: Paul Ibison
- Re: Merge Replication - Fast Sync
- Prev by Date: Re: Deadlock between Distribution Agent and Distribution Agent Cleanup
- Next by Date: Re: Deadlock between Distribution Agent and Distribution Agent Cleanup
- Previous by thread: Deadlock between Distribution Agent and Distribution Agent Cleanup
- Next by thread: Re: Merge Replication - Fast Sync
- Index(es):
Relevant Pages
|
Loading