|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
CPU maximums & multicore CPUs
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. -- Show quoteHide quoteGeoff N. Hiten Senior Database Administrator Microsoft SQL Server MVP "Debbie" <Deb***@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. Show quoteHide quote "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" <Deb***@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 -- Show quoteHide quoteThis 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" <Deb***@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" <Deb***@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. :)
-- Show quoteHide quoteGeoff N. Hiten Senior Database Administrator Microsoft SQL Server MVP "Roger Wolter[MSFT]" <rwol***@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" <Deb***@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" <Deb***@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. -- Show quoteHide quoteGeoff N. Hiten Senior Database Administrator Microsoft SQL Server MVP "Debbie" <Deb***@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" <Deb***@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? >> > >> > >> >> >>  |
|||||||||||||||||||||||
Other interesting topics