Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Slow BCP Out, only 9000 rows/second

    Well..

    I know now why BCP was so "slow"

    Storage is fast and no CPU or Memory pressure. However, with a table with 1.5 billion rows and doing a BCP will give...

    June 1, 2016 at 5:54 am

    #1882414

  • RE: Slow BCP Out, only 9000 rows/second

    Eirikur Eiriksson (5/30/2016)

    Quick question, what value are you passing with the [-a packetsize] parameter? IIRC, if none is passed it will revert to the default 4096k

    😎

    tried 64k, 32k and nothing

    64k...

    May 30, 2016 at 4:36 am

    #1881987

Viewing 2 posts - 1 through 2 (of 2 total)