February 2, 2005 at 7:03 am
i have a publisher (sqlsrv 2000 standard) and 3 subscribers (msde,push), connected by isdn lines.
when i make update operations at publisher (over 100 rows), the subscribers need more than 10 min to syncronize. the processor at publisher is not used, the isdn link is not used, but the processor at subscriber stay high (100% usage).
I used profiler and every sp_upd_xxxxxx executed took more than 2 seconds.
at insert and deletes all is normal
is something about msde, is slower than other editions on replication?
February 7, 2005 at 8:00 am
This was removed by the editor as SPAM
February 8, 2005 at 2:16 am
Sorry, I don't have a solution but I can confirm that this should not happen I ran merge replication over ISDN line myself with much more updates and I've never had these problems.
One question: How are your mergen agents scheduled ? Do they run continously or once every couple of minutes. You might try to change the schedule.
M
[font="Verdana"]Markus Bohse[/font]
February 8, 2005 at 4:13 am
the agents are scheduled to run every two hours. I tried on other system (with vmware) and replication work great (about 60 changes/s). But here I have only 3-4 chages/s.
Computers have 512MB RAM for MSDN and 1GB for SQL Server Standard and database is small.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply