Post reply

JOB PERFOREMANCE

  • July 5, 2009 at 5:55 am

    #155913

    HI

    HOQ CAN I MEASURE THE PERFORMANCE OF A JOB>?

    I HAVE A JOB WITH ONE STEP AND IN THIS JOB I LOAP TO THE ROWS IN THE TABLE AND checking the time of each row if it is more than a value so i will delete this row and update a field in other table

    i want to find a way to check the performance of my job for 100000 record and to know when this record will be deleted and the delay which it take the job to be deleted

    I WANT A WAY TO KNOW HOW TO MEASURE PERFORMANCE I USE NOW SQL SERVER 2008 WHICH TYPE OF THE ALERT WILL HELP ME

    AND IF I WANT TO CREATE A JOB DUNAMICALLY HOW CAN I DO IT

  • July 5, 2009 at 6:09 am

    #1020051

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic747333-338-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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