Moved from: bobsql.com
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