Post reply

Error in sql

  • December 14, 2004 at 8:53 am

    #60895

    When running one of our procedures we get teh following error msg.

    "Error encountered with Exception Message: Intra-query parallelism caused your server command (process ID #51) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1)

    Has anyone seen this before?any resolution? any help will be greatly appreciated.

    TIA

  • December 14, 2004 at 9:43 am

    #533795

    I have seen this when a server was under high load. We talked with MS and they said to turn off parallelism. I thought there was a post SP3 fix (we caught this pre SP3)

  • December 14, 2004 at 9:52 am

    #533801

    Steve,

    Once you turned off parallelism did it impact anything else on that server. Apart from thsi did you do any changes to teh sql code? any help will be greatly apprecaited

    Thanks

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

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