|
Hi, i am facing the following issue. I have 4 logical cpu's(64 bit),4GB RAM .even after i increased the max number of working threads to 1024 i am facing the same problem.Please give me some suggestions on this.
(comments are locked)
|
|
The recommended value for max worker threads is 0 which allows SQL Server to automatically configure the number of worker threads at startup. This setting is best for most systems; however, depending on your system configuration, setting max worker threads to a specific value sometimes improves performance. But this does not prove good in your case. Also, after changing the max worker threads values, you need to restart the sytem for the new setting to take effect.
(comments are locked)
|
|
is it possible to increase(more than 400) max worker threads for my system configuration and can you tell me how memory is related to max worker threads.i restarted my system after changing the max worker threads. Yes it is possible to add more than 400. As per BOL, for 64 bit, <= 4 processors 512 max value is autoconfigured. Setting the max worker threads option to a small value may prevent enough threads from servicing incoming client requests in a timely manner and could lead to "thread starvation". However, setting the option to a large value can waste address space, because each active thread consumes 512 KB on 32-bit servers and up to 4 MB on 64-bit servers. I hope this will help you understand the relationship b/w Worker threads and Memory.
May 17 '12 at 11:31 AM
robbin
(comments are locked)
|
