SQL Server Performance

BCP OUT Tuning

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by joetig, Jan 6, 2010.

  1. joetig New Member

    Attempting to BCP a large resultset using a view and the queryout option. I have been playing with both the network packet size and the size of the batch using join conditions.
    When looking at the command line output file. What do the values in "Clock Time (ms.) Total" really signify. I am trying to measure the various methods to determine the optimal method.
    3,661,051 rows copied
    Network packet size (bytes): 32576
    Clock Time (ms.) Total 239578 Average : (15281.25 rows per sec.)
  2. MohammedU New Member

    Clock Time (ms.) Total is the # of ms taken to execute the bcp....
    select (Average)*(Clock Time (ms.) Total )/1000 = rows copied
    select 15281.25 *239.578 = 3661051
  3. joetig New Member

    Thank you for your response. It answered my question[:)]
  4. joetig New Member

Share This Page