August 12, 2013 at 4:31 pm
I have SQL 2008 Standard on two servers. Testing merge replication between the servers on two tables.
1. Both tables have about 500k records.
2. These servers are not in use currently, just being tested for replication, so there is very little if any changes to the data.
3. Set up and initialization seem fine.
4. The databases were identical when we started. Tried several methods, attach/detach, backup, etc...
5. When the Merge Agent runs the first time, there are 150,000 updated records. Next time, 42,810 records updated and 42,800 conflicts. Third time, is running now. Looks like 200k plus updates and conflicts. Taking about 90 minutes.
I first noticed this because the log file was getting huge when i had the timing on continuous. Now I have it on manual so i can track what is happening.
Any ideas what may be happening ?
Thanks in advance.
August 12, 2013 at 4:35 pm
is the volume consistent with actual modification of the table?
August 12, 2013 at 4:47 pm
Good question, but, to my knowledge there are no modifications to the tables. I have a couple people testing from a web site connection, but they would only be able to modify one record at a time. so 10 is a good number. Not 200k.
But I take it from your response, this is not normal? That is encouraging.
August 12, 2013 at 5:15 pm
I found it. Sorry for interrupting.
I had a job that was marking some email records as undeliverable. the same records over and over... easy fix.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply