Post reply

identifying agent job based on blocking spid

  • August 31, 2009 at 3:46 am

    #134648

    I have many jobs running, some of which are causing blocking.

    I can see the spid thats causing blocking but i cant link that to a particular job. Im getting the blocking spid, and the sql_handle, and using the handle im viewing the sql stext using dm_exec_sql_text. Unfortunately the jobs are quite big and call lots of sprocs etc.

    rather than combing through each job to see if it calls the code i found from dm_exec_sql_text, is there an easier way to link a spid to a running job?

  • August 31, 2009 at 7:04 am

    #1046850

    Hello Winston,

    Is blocking is temporary?

    Are you facing any deadlock problem?

    check this view:

    sys.dm_tran_locks

    HTH

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

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

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