Groups | Blog | Home
all groups > sql server replication > june 2006 >

sql server replication : async_network_io wait during replication


stephanie
6/7/2006 8:08:02 PM
I have re-initialize some subscription. After generated snapshot
successfully, the synchronization view showing 'The process is running and is
waiting for a response from the server.' and I found the replication process
is under 'async_network_io wait'. The job has run for more than 8 hrs. Any
Paul Ibison
6/8/2006 12:00:00 AM
I'd check on the subscriber that something is actually happening - you could
use profiler or dbcc inputbuffer (or dm_exec_sql_text for SQL Server 2005)
to see that the merge agent is actually doing some processing. If nothing is
happening, then I'd investigate network connectivity and bandwidth issues.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

AddThis Social Bookmark Button