High use of THREADPOOL

Hi Folks,

It has been a long time since my last post, and i would like to give tip about a problem that i had a few weeks ago. SQL Server was running on Hyper-V and the costumer was always complaining about performance in certain times of day, as we know SQL Server has a dmv called sys.dm_os_wait_stats. Looking to this DMV i saw a high use of THREADPOOL. According BOL THREADPOOL is:

Occurs when a task is waiting for a worker to run on. This can indicate that the maximum worker setting is too low, or that batch executions are taking unusually long, thus reducing the number of workers available to satisfy other batches.

After that, the only configuration that i know (might have more than one) is in the Server Properties the option “Maximum Worker Threads”.

As you can see in the picture the “Maximum worker threads” was setup with 128 workers, so i just put the value 0 (zero) because zero is the same meaning of default for this configuration and after that the high use of THREADPOOL disappeared and of course the SQL Server on Hyper-V is working fine again.

Best Regards,
Marcos Freccia

Sobre Marcos Freccia

MVP em SQL Server (Data Plataform) , especialista em SQL Server, e atualmente trabalhando com Microsoft Azure!

Publicado em setembro 5, 2011, em Administração, VirtualPass e marcado como , , , , . Adicione o link aos favoritos. Deixe um comentário.

Deixe uma resposta

Preencha os seus dados abaixo ou clique em um ícone para log in:

Logotipo do WordPress.com

Você está comentando utilizando sua conta WordPress.com. Sair / Alterar )

Imagem do Twitter

Você está comentando utilizando sua conta Twitter. Sair / Alterar )

Foto do Facebook

Você está comentando utilizando sua conta Facebook. Sair / Alterar )

Foto do Google+

Você está comentando utilizando sua conta Google+. Sair / Alterar )

Conectando a %s

%d blogueiros gostam disto: