Process ids blocked | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Process ids blocked

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
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.
Nothing much steps,just truncates table and copies data from other server.
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.
]]>