Today I was tracking a large BCP.exe ‘IN’ operation and monitoring thesys.dm_exec_requestsentries. The ‘BULK INSERT’ command entry appeared, showing the CPU, reads, writes, … but these values where getting reset from time to time. Here are 3 snapshots from my system.
Instead of a single BULK INSERT batch I saw multiple BULK INSERT batches taking place on the same session. When you specify the BCP, batch size (-b) the rows are streamed until the batch size is reached, a commit is issued and a new batch is started for subsequent rows. Thus, you see a series of BULK INSERT operations and not the BCP in it entirety.