max worker threads option

Hi,
I am working on a SQL server and the "Maximum worker threads" option is set
to zero. That seems strange to me.
What does that means? Does zero have special meaning for "Maximum worker
threads" option?
Thank you,
AlanA.M wrote:
> I am working on a SQL server and the "Maximum worker threads" option is se
t
> to zero. That seems strange to me.
> What does that means? Does zero have special meaning for "Maximum worker
> threads" option?
The default setting is 255, so how yours ended up at 0 seems odd. For
more information look at "max worker thread Option" in Books Online.
http://msdn.microsoft.com/library/e...config_09wu.asp
Aaron Weiker
http://aaronweiker.com/
http://www.sqlprogrammer.org/|||Thank you for reply.
I already went through books online. I haven't see any place explain the
meaning of the value zero for "Maximum worker threads". That is what I am
looking for.
Alan
"Aaron Weiker" <aaron@.sqlprogrammer.org> wrote in message
news:OPyv$g4DFHA.576@.TK2MSFTNGP15.phx.gbl...
> A.M wrote:
set
> The default setting is 255, so how yours ended up at 0 seems odd. For
> more information look at "max worker thread Option" in Books Online.
> http://msdn.microsoft.com/library/e...config_09wu.asp
> --
> Aaron Weiker
> http://aaronweiker.com/
> http://www.sqlprogrammer.org/|||A.M wrote:
> I already went through books online. I haven't see any place explain the
> meaning of the value zero for "Maximum worker threads". That is what I am
> looking for.
Glad to hear, so used to people not checking there first. It looks like
the values are only valid from 32-32767. So my guess would be that if it
is zero it defaults to either 32 or 255.
I would definitely be interested to know how it got set to 0, I would
think that there would be something internal to SQL to prevent this. And
also what it is actually using inside SQL.
Aaron Weiker
http://aaronweiker.com/
http://www.sqlprogrammer.org/