January 25, 2011 at 5:12 pm
hello, I have a merge publication that will not synchronize because the snapshot is obsolete.
when running the snapshot, it would hang with "[47%] The process is running and is waiting for a response from the server."
I have opened a ticket with microsoft premier support but so far he just had me extend the QueryTimeout from 30 minutes to 2hrs, then when it still timed out, he had me extend it to 4hrs. this is only a 22GB database.
when I run a select * from sys.sysprocesses and locate the spid for the snapshot job, I see its stuck on
SOS_SCHEDULER_YIELD
there is also a lot of I/O on both the database and transaction log files.
I have plenty of disk space for the snapshot, the database, and the transaction logs with over 150GB free.
the snapshot folder gets a new directory created that looks like a GUID, but its empty. It never actually gets to create a snapshot.
memory usage stays at a consistent 66%, and processor usage is around 5-10%.
in this particular case I have both instances on the same box, I have three publications, two of them are merging successfully, and one of them has this problem.
is there anything else I can do to troubleshoot this? I have already attempted to re-initialize the snapshot and I even removed over 2/3 of the articles and only have the ones that are absolutely necessary to replicate. Microsoft supprt has been addressing this at a glacial pace..
thanks
January 26, 2011 at 11:21 am
Did this get resolved? If so, it would be good to update with what you found. Thanks.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
January 26, 2011 at 8:11 pm
I am not sure from your post which agent is timing out - is it the snapshot or the merge agent.
Either way, another option you could use is to change the profile associated with the offending agent so that it reports on its activity more frequently. The slow bandwith profiles might be a start although they may report more frequently than you want.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply