Sp_server_diagnostics for WorkerThread

• Vets5

  SSC Eights!

  Points: 962

  More actions

  April 19, 2021 at 11:46 am

  #3873002

  Hi there,

  I am seeing excessively high number of worker threads when running Sp_server_diagnostics. My question is around the 3 figures:

  "queryProcessing maxWorkers="704" workersCreated="756" workersIdle="206""and how to interpret them.

  As you can see from the above we are certainly exceeding the maxWorkers  but I'm trying to understand if workerIdle comes into play here. Does this mean that of the workersCreated (756) that 206 of these are ideal or is it a case that we have 756 active and 206 idle?

  What's the best way to troubleshoot the source of the excessive thread?

  Many thanks,

  V

   

   

   

  • This topic was modified 3 years, 5 months ago by  Vets5.

• Site Owners

  SSC Guru

  Points: 80338

  More actions

  April 20, 2021 at 12:10 pm

  #3873461

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.