Post reply

Does OS CPU limit lower SQL Server 2008 R2 CPU maximum

  • March 29, 2011 at 1:52 pm

    #389168

    Windows Server 2008 R2 Standard can only utilize 4 CPUs. SQL Server 2008 R2 Enterprise Edition can utilize 8 CPUs. If you install SQL Server 2008 R2 Enterprise Edition on a server that is using Windows Server 2008 R2 Standard, can SQL still use 8 CPUs or is it limited by the 4 CPUs that the OS can only use?

  • March 29, 2011 at 3:30 pm

    #1305170

    I havnt actually tried this but I wouldnt think so. But I can tell you that running two instances of SQL R2 Standard on the same box as Server Enterprise with 8 sockets (4 cores on each) and splitting cores over the two instances (16 each) as well at the server RAM 64 gig on each instance, works a treat. We also have this clustered to a VM farm (passive) and again, it works brilliantly. Its quite a nifty way of getting round buying an Enterprise Licence

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply