I have DTS which has many taks and Packages inside it. If run them one by by , all are working fine. If I ran the DTS with all the task, it is failing wiht a error deadlock. What may be the reason?? ---------------------------------------- Contributing Editor, Writer & Forums Moderator http://www.SQL-Server-Performance.Com Visit my Blog at http://dineshasanka.spaces.live.com/
Reason is always the same waiting to get the resources for each other... Enable the traceflag 1204 and see what the procedures/statements causing deadlock... If you are running multiple insert/update/delete statements in DTS... by default four threads can run at a time... so change it to run one at a time...in dts properties... MohammedU. Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
yeah it worked ---------------------------------------- Contributing Editor, Writer & Forums Moderator http://www.SQL-Server-Performance.Com Visit my Blog at http://dineshasanka.spaces.live.com/
How did you resolve? MohammedU. Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
I set the paralel setting to 1 ---------------------------------------- Contributing Editor, Writer & Forums Moderator http://www.SQL-Server-Performance.Com Visit my Blog at http://dineshasanka.spaces.live.com/
I used the same technique when I had issue like this but it was not deadlock... Thanks.... MohammedU. Moderator SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
thanks for the info. It took me several days to find out the solution ---------------------------------------- Contributing Editor, Writer & Forums Moderator http://www.SQL-Server-Performance.Com Visit my Blog at http://dineshasanka.spaces.live.com/
