SQL Server Performance

Process ids blocked

Discussion in 'SQL Server DTS-Related Questions' started by hrishi, May 22, 2007.

  1. hrishi New Member

    Hi,


    We have production server in which dts job is running,when this job runs there will be blocking and after a few minutes it will fail ,when we try to kill the process ids it will show that it has been killed sucessfully but we still see the bloked process ids,but after the restart of sql server we can't see the bloked process id's ,can any one please reply me why its happening like this.

    Regards,
    Hrishi
  2. satya Moderator

    What steps you are using in that dts package?
    Enable the package logging to see which query is having such blocking and also you can find out using SP_WHO2.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. hrishi New Member

    Nothing much steps,just truncates table and copies data from other server.
  4. satya Moderator

    Then enable the DTS package logging to see more information.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page