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

Advertisements

About Marcos Freccia

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

Posted on September 5, 2011, in Administração, VirtualPass and tagged , , , , . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: