Post reply

Time taken by SQL Engine to run a job

  • March 16, 2011 at 11:36 am

    #236415

    Hello,

    In our environment, we have developed a SQL Script to monitor long running queries. I see an interesting values for one of the SQL Agent job (Update Stats). As per the view history of the job, time taken to complete the update stats is 25 min. But, total_elapsed_time from sys.dm_exec_requests is almost 201 min.

    Can somebody please explain what is the difference between agent job's run duration and elapsed time from the dmv.

    Thanks

    Thanks
    Jagan K

  • March 16, 2011 at 11:59 am

    #1299553

    Probably parallelism gets in the way, so that elapsed time is far less than CPU worker time.

    -- Gianluca Sartori

  • March 16, 2011 at 1:17 pm

    #1299611

    Parallelism was my guess as well, and would make sense if you had at least an 8 core machine. However, as far as you are concerned, it took 25 minutes to run..

    CEWII

  • March 16, 2011 at 1:17 pm

    #1299612

    Parallelism was my guess as well, and would make sense if you had at least an 8 core machine. However, as far as you are concerned, it took 25 minutes to run..

    CEWII

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

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