Re: SQL 2005 Workgroup Edition memory limit.



It the case of WorkGroup it is limited to two CPUs. So it will limit to 2 of
the 4 cores.


"Steve Dybing [MSFT]" <steve.dybing@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:eotXj$FdGHA.4912@xxxxxxxxxxxxxxxxxxxxxxx
It'll be limited in what it can use so it will install and run just fine.
It won't use more than 3GB of memory but SQL Server does include support
for multicore processors and hyperthreaded processors so it will take
advantage of all 4 of the "processors" that it sees.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

--
Sincerely,
Steve Dybing

This posting is provided "AS IS" with no warranties, and confers no
rights.
"Michael ValeCruz" <mvalecruz6@xxxxxxxxxx> wrote in message
news:OdjSPgEdGHA.2456@xxxxxxxxxxxxxxxxxxxxxxx
Can SQL 2005 Workgroup Edition be installed on a Server that has more
than 3GB of memory. Also it looks like it counting my two XEON processor
as 4. Is the limitation based on what it going to use or will it not
function on a box that exceeds it limits?

Comment please,
Michael ValeCruz





.



Relevant Pages

  • Re: Intel details future Larrabee graphics chip
    ... for dinky little SMP systems of 4-8 cores. ... Why multi-thread *anything* when hundreds or thousands of CPUs are ... video CPUs using fancy memory and generics doing the grunt work. ... Duo, and never get trojans, memory leaks, any of that. ...
    (sci.electronics.design)
  • Re: HARSH article on TheRegister - Jobs lied about Intel speed, doesnt care about computers now
    ... They have 2 cores, not 2 CPUs. ... L2 cache or the shared access to main memory. ... This is one place that Opteron wins over Xeon; ...
    (uk.comp.sys.mac)
  • Re: Intel details future Larrabee graphics chip
    ... That is precisely how the early SMP systems worked, ... for dinky little SMP systems of 4-8 cores. ... Why multi-thread *anything* when hundreds or thousands of CPUs are ... It could be useful for 3D gaming, but even there it still makes sense to split the load across specialised dedicated video CPUs using fancy memory and generics doing the grunt work. ...
    (sci.electronics.design)
  • Re: Question on scalability of multi-core Processors
    ... that of the cores in the previous generation. ... If we have CPUs with a uniform set of cores, ... talking to some memory. ... the big advantage of a separate graphics chip is that it it gives you a ...
    (comp.arch)
  • Re: Verbose functional languages?
    ... Speaking of multiple cores: when I look at what's Intel talking about, ... Even memory allocation would create all kinds of mutual wait ... I'm less convinced about general use of semi-space moving collectors ...
    (comp.lang.functional)