SQL Server Performance

Deadlock

Discussion in 'SQL Server DTS-Related Questions' started by dineshasanka, Apr 6, 2007.

  1. dineshasanka Moderator

    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/
  2. MohammedU New Member

    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.
  3. dineshasanka Moderator

    yeah it worked

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/
  4. MohammedU New Member

    How did you resolve?

    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  5. dineshasanka Moderator

    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/
  6. MohammedU New Member

    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.
  7. dineshasanka Moderator

    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/

Share This Page