Home Forums SQL Server 2017 SQL Server 2017 - Administration How many workers can I use and how many are active? RE: How many workers can I use and how many are active?

  • December 19, 2017 at 6:13 am

    #1972666

    kevaburg - Monday, December 18, 2017 8:00 AM

    We are trying to troubleshoot a problem that seems to be the result of too many threads being allocated to queries.  We came to this conclusion after seeing the THREADPOOL (poison) wait becoming more and more prominent as a SQL Server wait stat.

    What is the actual problem that you're trying to troubleshoot?  Is it performance or something else?  I ask because I've found that things like "the THREADPOOL (poison) wait becoming more and more prominent as a SQL Server wait stat" is a symptom of a larger problem and trying to fix the symptom rather than the cause is usually a futile cause that sometimes causes more harm than good.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)