Results 1 to 4 of 4
  1. #1
    Join Date
    May 2010
    Posts
    52

    Unanswered: Tracking updated rows.

    so i have an update query that is updating 50k rows per batch. my question is how do i campture how long it is taking to update 50k rows per batch.

  2. #2
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    Use a timer.

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    After each batch update, you can use SELECT GETDATE(), and insert this into a table, or just spit out the result to the screen. One problem with the screen update, though, is that SQL Server usually waits to send back results only after it has filled up a network block (about 4k). If you use PRINT, you can get around that, though.

  4. #4
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    Why not use client stats which gives execution time or set stats on?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •