Sunday, February 19, 2012

Hyper Threaded Processor Support

Hi,
I know that this must have been answered many times before but looking at
the supported processors for SQL 2000 or 2005 when it mentions maximum
number of processors is this the maximum physical processors? If Standard
edition supports 4 processors, is this 2 hyper threaded or 4 hyper threaded
processors?
Thanks
Chris Wood
Hi
Standard supports 4 processor sockets, so on a HT or dual core, it looks
like 8 processors to the OS and SQL Server. That is supported andworks. SQL
Server 2000 SP3 added support for HT processors.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:OvdHCapyFHA.720@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I know that this must have been answered many times before but looking at
> the supported processors for SQL 2000 or 2005 when it mentions maximum
> number of processors is this the maximum physical processors? If Standard
> edition supports 4 processors, is this 2 hyper threaded or 4 hyper
> threaded processors?
> Thanks
> Chris Wood
>
|||Sorry to sound dumb Mike.
SQL2005 Standard supports 4 processors which could be 4 hyper-threaded
processors or 4 dual core processors or 4 single core processors without HT?
Chris
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:u3DYrcpyFHA.2072@.TK2MSFTNGP14.phx.gbl...
> Hi
> Standard supports 4 processor sockets, so on a HT or dual core, it looks
> like 8 processors to the OS and SQL Server. That is supported andworks.
> SQL Server 2000 SP3 added support for HT processors.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
> news:OvdHCapyFHA.720@.TK2MSFTNGP15.phx.gbl...
>
|||This issue confuses everyone so don't feel dumb. SQL was released before
Hyperthreadong or dual-core processors. When Hyperthreading was released,
MS eventually came to the decision to license processor sockets, not cores
or virtual processors. So, you count actual, physical processors for
licensing. SQL Service Pack 2 has the correct code to count processor
sockets, not processors. SP3a and SP4 have some code tweaks to better deal
with some synchronization issues from HT and Multi-core processors.
Again, do not worry about the logical processor count shown in Windows.
Count the actual physical processors for correct licensing and limitations.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:%23AoCN1pyFHA.464@.TK2MSFTNGP15.phx.gbl...
> Sorry to sound dumb Mike.
> SQL2005 Standard supports 4 processors which could be 4 hyper-threaded
> processors or 4 dual core processors or 4 single core processors without
> HT?
> Chris
> "Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
> news:u3DYrcpyFHA.2072@.TK2MSFTNGP14.phx.gbl...
>
|||Thanks for clearing that up Geoff.
Chris
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:u0AeGGqyFHA.1264@.tk2msftngp13.phx.gbl...
> This issue confuses everyone so don't feel dumb. SQL was released before
> Hyperthreadong or dual-core processors. When Hyperthreading was released,
> MS eventually came to the decision to license processor sockets, not cores
> or virtual processors. So, you count actual, physical processors for
> licensing. SQL Service Pack 2 has the correct code to count processor
> sockets, not processors. SP3a and SP4 have some code tweaks to better
> deal with some synchronization issues from HT and Multi-core processors.
> Again, do not worry about the logical processor count shown in Windows.
> Count the actual physical processors for correct licensing and
> limitations.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
> news:%23AoCN1pyFHA.464@.TK2MSFTNGP15.phx.gbl...
>

No comments:

Post a Comment