Post reply

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

  • 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

  • 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

  • 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

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

You must be logged in to reply to this topic. Login to reply