MAX Worker threads ...

We just upgraded our database server to 8 processors and 24 GB RAM. With the
hyperthreading, SQL Server is recognizing 16 processors. It looks like some
of the processors are running at less than 5%. I'm wondering if turning up
the number of max threads will spread the load across the processors better.
Thanks,
Bob Castleman
DBA PoseurHmmm ...
Maybe not?
According to BOL, if I reach the MAX Worker Threads threshold there should
be an entry in the SQL Log. I don't see any so I don't think this is it.
"Bob Castleman" <nomail@.here> wrote in message
news:undKflbfFHA.1480@.TK2MSFTNGP10.phx.gbl...
> We just upgraded our database server to 8 processors and 24 GB RAM. With
> the hyperthreading, SQL Server is recognizing 16 processors. It looks like
> some of the processors are running at less than 5%. I'm wondering if
> turning up the number of max threads will spread the load across the
> processors better.
> Thanks,
> Bob Castleman
> DBA Poseur
>|||Bob,
It's unlikely you are running out of worker threads and if you do you will
see error msgs stating you are out of worker threads. Adding more threads
does not spread the load better. SQL Server already evenly divides the
worker threads across each UMS or CPU. That way each one has a pool of
threads to use.
--
Andrew J. Kelly SQL MVP
"Bob Castleman" <nomail@.here> wrote in message
news:undKflbfFHA.1480@.TK2MSFTNGP10.phx.gbl...
> We just upgraded our database server to 8 processors and 24 GB RAM. With
> the hyperthreading, SQL Server is recognizing 16 processors. It looks like
> some of the processors are running at less than 5%. I'm wondering if
> turning up the number of max threads will spread the load across the
> processors better.
> Thanks,
> Bob Castleman
> DBA Poseur
>