2005 Max CPU's

I need some clarification on the maximum number of CPUs that will be used by
SQL Server Standard Edition. The documentation states that 4 CPUs is the
maximum for Standard. If those 4 CPUs are dual core, will SQL Server
utilize all 8 logical CPUs? I read some posts that indicated that only 4
of the 8 logical CPUs will be used by SQL Server Standard Edition. Is this
true?
Thanks!
ChrisChris,
CPUs are physical chips, whether single, dual, or quad core. In a
conversation from a few months ago Jens K. Suessmeyer pointed to the
explanation about SQL Server Express over the same issue:
http://support.microsoft.com/kb/914278/en-us
RLF
"Chris Gallelli" <Chris.Gallelli@.hotmail.com> wrote in message
news:uQ25vsfXIHA.4808@.TK2MSFTNGP05.phx.gbl...
>I need some clarification on the maximum number of CPUs that will be used
>by SQL Server Standard Edition. The documentation states that 4 CPUs is
>the maximum for Standard. If those 4 CPUs are dual core, will SQL Server
>utilize all 8 logical CPUs? I read some posts that indicated that only 4
>of the 8 logical CPUs will be used by SQL Server Standard Edition. Is this
>true?
> Thanks!
> Chris
>|||Russell,
Thanks for the quick response. Your answer gives me some more insight into
the Express edition but I am looking specifically at SQL Server 2005
Standard Edition. If a machine running SQL Server 2005 Standard Edition has
4 Dual Core Processors, will SQL Server use all 8 logical CPUs?
The following link contains a discussion that is asking the same question:
http://www.codeprof.com/dev-archive/120/19-95-1201327.shtm
"Russell Fields" <russellfields@.nomail.com> wrote in message
news:%23UK7czfXIHA.484@.TK2MSFTNGP06.phx.gbl...
> Chris,
> CPUs are physical chips, whether single, dual, or quad core. In a
> conversation from a few months ago Jens K. Suessmeyer pointed to the
> explanation about SQL Server Express over the same issue:
> http://support.microsoft.com/kb/914278/en-us
> RLF
> "Chris Gallelli" <Chris.Gallelli@.hotmail.com> wrote in message
> news:uQ25vsfXIHA.4808@.TK2MSFTNGP05.phx.gbl...
>>I need some clarification on the maximum number of CPUs that will be used
>>by SQL Server Standard Edition. The documentation states that 4 CPUs is
>>the maximum for Standard. If those 4 CPUs are dual core, will SQL Server
>>utilize all 8 logical CPUs? I read some posts that indicated that only 4
>>of the 8 logical CPUs will be used by SQL Server Standard Edition. Is
>>this true?
>> Thanks!
>> Chris
>|||Hi Chris
Yes, SQL 2005 Std Edn definitely uses all 8 CPUs. The restriction is only
for physical CPUs, not logical so it's possible to have 4 Quad Core CPUs
with 16 logical all working under SQL 2005 Std Edn
Regards,
Greg Linwood
SQL Server MVP
http://blogs.sqlserver.org.au/blogs/greg_linwood
Benchmark your query performance
http://www.SQLBenchmarkPro.com
"Chris Gallelli" <Chris.Gallelli@.hotmail.com> wrote in message
news:%23jBFhMgXIHA.4476@.TK2MSFTNGP06.phx.gbl...
> Russell,
> Thanks for the quick response. Your answer gives me some more insight
> into the Express edition but I am looking specifically at SQL Server 2005
> Standard Edition. If a machine running SQL Server 2005 Standard Edition
> has 4 Dual Core Processors, will SQL Server use all 8 logical CPUs?
> The following link contains a discussion that is asking the same question:
> http://www.codeprof.com/dev-archive/120/19-95-1201327.shtm
>
> "Russell Fields" <russellfields@.nomail.com> wrote in message
> news:%23UK7czfXIHA.484@.TK2MSFTNGP06.phx.gbl...
>> Chris,
>> CPUs are physical chips, whether single, dual, or quad core. In a
>> conversation from a few months ago Jens K. Suessmeyer pointed to the
>> explanation about SQL Server Express over the same issue:
>> http://support.microsoft.com/kb/914278/en-us
>> RLF
>> "Chris Gallelli" <Chris.Gallelli@.hotmail.com> wrote in message
>> news:uQ25vsfXIHA.4808@.TK2MSFTNGP05.phx.gbl...
>>I need some clarification on the maximum number of CPUs that will be used
>>by SQL Server Standard Edition. The documentation states that 4 CPUs is
>>the maximum for Standard. If those 4 CPUs are dual core, will SQL Server
>>utilize all 8 logical CPUs? I read some posts that indicated that only
>>4 of the 8 logical CPUs will be used by SQL Server Standard Edition. Is
>>this true?
>> Thanks!
>> Chris
>>
>|||Sorry. (But I thought the analogy carried through just fine.) - RLF
"Chris Gallelli" <Chris.Gallelli@.hotmail.com> wrote in message
news:%23jBFhMgXIHA.4476@.TK2MSFTNGP06.phx.gbl...
> Russell,
> Thanks for the quick response. Your answer gives me some more insight
> into the Express edition but I am looking specifically at SQL Server 2005
> Standard Edition. If a machine running SQL Server 2005 Standard Edition
> has 4 Dual Core Processors, will SQL Server use all 8 logical CPUs?
> The following link contains a discussion that is asking the same question:
> http://www.codeprof.com/dev-archive/120/19-95-1201327.shtm
>
> "Russell Fields" <russellfields@.nomail.com> wrote in message
> news:%23UK7czfXIHA.484@.TK2MSFTNGP06.phx.gbl...
>> Chris,
>> CPUs are physical chips, whether single, dual, or quad core. In a
>> conversation from a few months ago Jens K. Suessmeyer pointed to the
>> explanation about SQL Server Express over the same issue:
>> http://support.microsoft.com/kb/914278/en-us
>> RLF
>> "Chris Gallelli" <Chris.Gallelli@.hotmail.com> wrote in message
>> news:uQ25vsfXIHA.4808@.TK2MSFTNGP05.phx.gbl...
>>I need some clarification on the maximum number of CPUs that will be used
>>by SQL Server Standard Edition. The documentation states that 4 CPUs is
>>the maximum for Standard. If those 4 CPUs are dual core, will SQL Server
>>utilize all 8 logical CPUs? I read some posts that indicated that only
>>4 of the 8 logical CPUs will be used by SQL Server Standard Edition. Is
>>this true?
>> Thanks!
>> Chris
>>
>