How It Works: BULK INSERT (BCP) TDS Traffic

Moved from:


Yesterday I had a discussion with a customer and realized that the BCP, TDS pattern could use a bit of documentation.


Customer Scenario/Question: I am using BCP.exe to import a large data set.   BCP.exe takes 15 minutes to complete but I only see a few seconds for the BULK INSERT command when monitoring dm_exec_requests.  What is taking so long if the BULK INSERT is only showing a few seconds in dm_exec_requests?

The customer was correct in her observation.  The BCP.exe takes 15 minutes and dm_exec_requests only shows a few seconds for the BULK INSERT