Seeing how many rows a query has inserted before it's done

• auaiomrn

  Ten Centuries

  Points: 1300

  More actions

  March 3, 2009 at 3:30 pm

  #129367

  Hi, I have a query that's taking longer than usual to run. It's basically just a straight copy from one table to another. (Note this is SQL 2000 SP4).

  I can see in "current activity" that the Physical IO is increasing so I know it's still going. My question is: Is there a way to see how many rows it has inserted so far? I know how many it has to do so I'd like to know how much longer it will run.

  Is there a way maybe to calculate how much data it has inserted from the "Physical IO" column in "current activity"?

  Thanks

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  March 3, 2009 at 4:05 pm

  #952778

  Query destination table using NOLOCK table hint.

  http://msdn.microsoft.com/en-us/library/ms187373.aspx

  MJ

• noeld

  SSC Guru

  Points: 96590

  More actions

  March 3, 2009 at 4:24 pm

  #952788

  Note that using nolock does not provides "accurate" values but it could serve as a "guesstimate"

  
  * Noel