I have been reading the licensing information for SQL 2005 as it relates to
logical CPUs (hyperthreading or multicores) but all of the white papers I am
reading cover the Per Processor model when addressing this.
Does anyone know, when not using the Per Processor model (i.e. Per Server
with either Device or User CALs) does the same logic apply? In other words,
if I have a server with 4 physical CPUs that do hyperthreading, can I run
Standard Edition and use all eight or do I need to go to Enterprise Edition
to use more than 4 CPUs?The processor limits apply regardless of the licensing model. Standard
Edition SQL 2005 supports up to four processors. This is counted as
processor sockets, just like for per-processor licensing, so ignore extra
logical processors due to hyperthreading or multi-core processors. SQL will
see the logical processors and use them correctly.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Debbie" <Debbie@.discussions.microsoft.com> wrote in message
news:AC408A92-B26A-4C5C-A72D-9D52341034B9@.microsoft.com...
>I have been reading the licensing information for SQL 2005 as it relates to
> logical CPUs (hyperthreading or multicores) but all of the white papers I
> am
> reading cover the Per Processor model when addressing this.
> Does anyone know, when not using the Per Processor model (i.e. Per Server
> with either Device or User CALs) does the same logic apply? In other
> words,
> if I have a server with 4 physical CPUs that do hyperthreading, can I run
> Standard Edition and use all eight or do I need to go to Enterprise
> Edition
> to use more than 4 CPUs?
>|||Thanks for the response. Just one thing. Do you know if this is spelled out
anywhere on Microsoft's site. I realize it can be inferred by what is stated
in most of the papers they have on licensing models but I have management who
would feel better if it was spelled out.
"Geoff N. Hiten" wrote:
> The processor limits apply regardless of the licensing model. Standard
> Edition SQL 2005 supports up to four processors. This is counted as
> processor sockets, just like for per-processor licensing, so ignore extra
> logical processors due to hyperthreading or multi-core processors. SQL will
> see the logical processors and use them correctly.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Debbie" <Debbie@.discussions.microsoft.com> wrote in message
> news:AC408A92-B26A-4C5C-A72D-9D52341034B9@.microsoft.com...
> >I have been reading the licensing information for SQL 2005 as it relates to
> > logical CPUs (hyperthreading or multicores) but all of the white papers I
> > am
> > reading cover the Per Processor model when addressing this.
> >
> > Does anyone know, when not using the Per Processor model (i.e. Per Server
> > with either Device or User CALs) does the same logic apply? In other
> > words,
> > if I have a server with 4 physical CPUs that do hyperthreading, can I run
> > Standard Edition and use all eight or do I need to go to Enterprise
> > Edition
> > to use more than 4 CPUs?
> >
> >
>
>|||Try this:
http://download.microsoft.com/download/e/c/a/ecafe5d1-b514-48ab-93eb-61377df9c5c2/SQLServer2005Licensing.doc
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Debbie" <Debbie@.discussions.microsoft.com> wrote in message
news:821BCA71-9E02-4E82-AB54-C2105B227503@.microsoft.com...
> Thanks for the response. Just one thing. Do you know if this is spelled
> out
> anywhere on Microsoft's site. I realize it can be inferred by what is
> stated
> in most of the papers they have on licensing models but I have management
> who
> would feel better if it was spelled out.
> "Geoff N. Hiten" wrote:
>> The processor limits apply regardless of the licensing model. Standard
>> Edition SQL 2005 supports up to four processors. This is counted as
>> processor sockets, just like for per-processor licensing, so ignore extra
>> logical processors due to hyperthreading or multi-core processors. SQL
>> will
>> see the logical processors and use them correctly.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>>
>> "Debbie" <Debbie@.discussions.microsoft.com> wrote in message
>> news:AC408A92-B26A-4C5C-A72D-9D52341034B9@.microsoft.com...
>> >I have been reading the licensing information for SQL 2005 as it relates
>> >to
>> > logical CPUs (hyperthreading or multicores) but all of the white papers
>> > I
>> > am
>> > reading cover the Per Processor model when addressing this.
>> >
>> > Does anyone know, when not using the Per Processor model (i.e. Per
>> > Server
>> > with either Device or User CALs) does the same logic apply? In other
>> > words,
>> > if I have a server with 4 physical CPUs that do hyperthreading, can I
>> > run
>> > Standard Edition and use all eight or do I need to go to Enterprise
>> > Edition
>> > to use more than 4 CPUs?
>> >
>> >
>>|||http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Notice the comments section across from Number of CPUs in the section titled
"Scalability and Performance" indicating support for multi-core processors.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Debbie" <Debbie@.discussions.microsoft.com> wrote in message
news:821BCA71-9E02-4E82-AB54-C2105B227503@.microsoft.com...
> Thanks for the response. Just one thing. Do you know if this is spelled
> out
> anywhere on Microsoft's site. I realize it can be inferred by what is
> stated
> in most of the papers they have on licensing models but I have management
> who
> would feel better if it was spelled out.
> "Geoff N. Hiten" wrote:
>> The processor limits apply regardless of the licensing model. Standard
>> Edition SQL 2005 supports up to four processors. This is counted as
>> processor sockets, just like for per-processor licensing, so ignore extra
>> logical processors due to hyperthreading or multi-core processors. SQL
>> will
>> see the logical processors and use them correctly.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>>
>> "Debbie" <Debbie@.discussions.microsoft.com> wrote in message
>> news:AC408A92-B26A-4C5C-A72D-9D52341034B9@.microsoft.com...
>> >I have been reading the licensing information for SQL 2005 as it relates
>> >to
>> > logical CPUs (hyperthreading or multicores) but all of the white papers
>> > I
>> > am
>> > reading cover the Per Processor model when addressing this.
>> >
>> > Does anyone know, when not using the Per Processor model (i.e. Per
>> > Server
>> > with either Device or User CALs) does the same logic apply? In other
>> > words,
>> > if I have a server with 4 physical CPUs that do hyperthreading, can I
>> > run
>> > Standard Edition and use all eight or do I need to go to Enterprise
>> > Edition
>> > to use more than 4 CPUs?
>> >
>> >
>>|||You win. Your link is better than my link. :)
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:uQDAdMHHGHA.648@.TK2MSFTNGP14.phx.gbl...
> Try this:
> http://download.microsoft.com/download/e/c/a/ecafe5d1-b514-48ab-93eb-61377df9c5c2/SQLServer2005Licensing.doc
>
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Debbie" <Debbie@.discussions.microsoft.com> wrote in message
> news:821BCA71-9E02-4E82-AB54-C2105B227503@.microsoft.com...
>> Thanks for the response. Just one thing. Do you know if this is spelled
>> out
>> anywhere on Microsoft's site. I realize it can be inferred by what is
>> stated
>> in most of the papers they have on licensing models but I have management
>> who
>> would feel better if it was spelled out.
>> "Geoff N. Hiten" wrote:
>> The processor limits apply regardless of the licensing model. Standard
>> Edition SQL 2005 supports up to four processors. This is counted as
>> processor sockets, just like for per-processor licensing, so ignore
>> extra
>> logical processors due to hyperthreading or multi-core processors. SQL
>> will
>> see the logical processors and use them correctly.
>> --
>> Geoff N. Hiten
>> Senior Database Administrator
>> Microsoft SQL Server MVP
>>
>>
>> "Debbie" <Debbie@.discussions.microsoft.com> wrote in message
>> news:AC408A92-B26A-4C5C-A72D-9D52341034B9@.microsoft.com...
>> >I have been reading the licensing information for SQL 2005 as it
>> >relates to
>> > logical CPUs (hyperthreading or multicores) but all of the white
>> > papers I
>> > am
>> > reading cover the Per Processor model when addressing this.
>> >
>> > Does anyone know, when not using the Per Processor model (i.e. Per
>> > Server
>> > with either Device or User CALs) does the same logic apply? In other
>> > words,
>> > if I have a server with 4 physical CPUs that do hyperthreading, can I
>> > run
>> > Standard Edition and use all eight or do I need to go to Enterprise
>> > Edition
>> > to use more than 4 CPUs?
>> >
>> >
>>
>
