title: SQL Replication Error (On Server Agent)
body: <p>I have created the new replication. Now what is issue I am facing:</p>
  
  <p>When I go to ​start the <code>'View Agent Snapshot Status'</code> Its just start working and First line shows "Starting Agent" and just keep working, working and continuously working. </p>
  
  <p>.<a href="https://i.stack.imgur.com/wn8QE.png" rel="noreferrer"><img src="https://i.stack.imgur.com/wn8QE.png" alt="enter image description here"></a>. </p>
  
  <p>After sometime it show the following message:
  "The replication agent has not logged a progress message in 10 minutes. This might indicate an unresponsive agent or high system activity. Verify that records are being replicated to the destination and that connections to the Subscriber, Publisher, and Distributor are still active." </p>
  
  <p><a href="https://i.stack.imgur.com/X9cxf.png" rel="noreferrer"><img src="https://i.stack.imgur.com/X9cxf.png" alt="enter image description here"></a></p>
  
  <p>I try the following solution that I found, I have increased the value of @HeartBeat_interval property of distributor from 10 to 30 but no success. </p>
  
  <p>I have Sql Server 2008 R2.</p>
  
  <p>any help will be appreciated really.</p>