Results 1 to 2 of 2

Thread: Potential deadlocks

  1. #1
    Join Date
    Jul 2009

    Potential deadlocks


    My SQL error logs are fillling with below error message:

    Error 17884
    Potential deadlocks exist on all schedulers

    my server has 8 processors and I am running SQL 2000 Ent edi SP4 on windows server 2003 SP2 ent edi.

    and I am experiencing connection timeout errors intermittently.

    max worker threads option in SP_configure is set to 255. does that make any difference in 8 rocessor scenario?

    how do I overcome this situation. it has been a headache for last week or so.

    pls help

  2. #2
    Join Date
    Sep 2002
    Value of max worker threads will affect number of active concurrent connections.

    For your issue, take look at this link:

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts