title: .Net SqlClient BULK INSERT hanging
body: <p>We are using .Net SqlClient to bulk insert data from a remote server to our SQL Server.</p>
  
  <p>Somedays our ETL fails so we are trying to figure out the reason for that.</p>
  
  <p>What we can notice is that a bulk insert, let's call it BI1 is hanging for too long compared to other bulk inserts started at the same time.</p>
  
  <p>By monitoring the running queries on our SQL server we can see that this BI1 query is changing status, sometimes "<code>suspended</code>", sometimes "<code>runnable</code>". I have not seen "running" at the moment, but maybe it is very fast when it is running and I don't see it between my refresh queries.
  When it is "<code>suspended</code>" (most of the time), the wait type is "<code>ASYNC_NETWORK_IO</code>". The row count is always the same : 38.</p>
  
  <p>My understanding is that the bulk insert is waiting to be fed with data to insert. Am I right?</p>
  
  <p>The question here is how do I identify the underlying issue?</p>
  
  <p>I already ruled out the network issue as there are other processes between these 2 machines at the same time which are completing successfully.
  The destination table is pretty big (7M+ rows), but inserting seems to work fine and fast.</p>