• I can't say that you don't have a problem, but the pageiolatch_ex just means that there is an exclusive latch placed on databaseID 13, fileID 1, and pageID 6938984.  And yes, I would expect to see exclusive latches acquired on a batch insert operation.  If you repeat the select statement and see the same page being locked for several iterations, you have a problem.  Basically latches are locks placed on the data pages as they are read into memory from disk.  This prevents the page from being changed by another process during the IO operation.

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/