Post reply

Index Causing Deadlock on thread - HELP

  • January 15, 2004 at 4:43 pm

    #490327

    maybe change to specifically mention "inner join" in the query?

    Not sure, this is a strange one.

  • January 16, 2004 at 4:09 am

    #490381

    Do you have more then one processor at this server ? If so, may be the optimizer choose paralelism to resolve the query. If that´s true, try to rewrite the query especifiing the hint (MAXDOP=1). I´ve already have problems with deadlocks in queries that use parelelism for execution, and I solve with this trick. 

  • January 22, 2004 at 7:33 am

    #491121

    psribeiro, you nailed it

    I added the OPTION MAXDOP=1 to my query and it no longer used parralelism in the estimated execution plan and the query worked bringing back a large amount of data, which was the problem.

    Thanks a lot

Viewing 3 posts - 1 through 4 (of 4 total)

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