December 13, 2013 at 7:45 am
I have a merge replication setup that has been working for awhile but now it is not.
The merge jobs run and hang. I setup verbose logging and everything looks normal until the end where the log just hangs at "Downloading data changes to the subscriber."
I've checked network connection and that all services are running on all servers.
There aren't any errors in the SQL log or the event log.
Replication monitor just hangs there.
The replication job runs , but locks the entire database down and the job never finishes.
Has anyone seen something like this?
December 13, 2013 at 7:50 am
Have you rebuilt the indexes for the merge metadata tables? I have seen those cause some really odd issues in the past.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 13, 2013 at 8:50 am
Are those within the distribution DB or within the publisher DB?
If i run some queries against the sys.dm_db_index_physical_stats I don't see many high fragmentation levels.
December 13, 2013 at 12:33 pm
In the publisher database is where you will most likely have the issue here. I would rebuild all the MS* tables, even if they don't get too fragmented. You could mark the tables for recompile as well but doing a rebuild on the indexes is recommended.
Also, do you have a job running to clean up the merge metadata? sp_mergemetadatacleanup is what you want to run.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply