Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
 Posted - 2008-07-01 : 03:38:47
|
| anyone knows what is the recommended maximum value that can be set for the max_worker_threads for tsql subsystem?for 64 bit and 32 bit...thanks in advance,Jen--------------------keeping it simple... |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-01 : 09:02:03
|
| It depends on no of CPUs. We go with default and let SQL server decide on it. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2008-07-02 : 09:26:47
|
ok... let's say you have 1 cpu, duo core, 64 bit.How many worker threads can be used?On the syssubsystems table, does the max_worker_threads correspond to the total or per CPU?The default does not work for us anymore.. I see queued up jobs.But I managed to reach a magic number (but not optimum since it was an educated guess) and that solved our problem.What I'm really asking is a formula or best practice. Again, the default does not work anymore :) but thanks for the reply.quote:
Originally posted by sodeep
It depends on no of CPUs. We go with default and let SQL server decide on it.
--------------------keeping it simple... |
|
|
|
maninder
Posting Yak Master
100 Posts |
Posted - 2008-07-02 : 13:19:00
|
| http://blogs.msdn.com/khen1234/archive/2005/11/07/489778.aspxManinder |
|
|
|
|
|
|
syssubsystems:max_worker_threads