June 7, 2012 at 9:32 pm
Hi everyone,
My organization has a plan to upgrade current SQL Server version from 2005 to 2012.
We will be using the same physical server for the upgrade.
At the same time, we intend to upgrade the OS version from Windows Server 2003 to Windows Server 2008 R2.
Server Spec:
Model: HP ProLiant DL580 G5
CPU: Intel(R) Xeon(R) CPU E7320 @ 2.13GHz (4x Quad Core)
RAM: 12GB
We will not be getting another server to perform the upgrade, so we will be formatting the current server to do the upgrade.
Here is the situation:
Currently we are on Server + CAL license, and we will be switching to Processor License.
On Processor license, due to budget contraints, we have only gotten 2 Processor License, that means we will downgrade from 4CPU to 2CPU.
My question is, will we still be able to use the same server (4CPU) but configure Processor Affinity in SQL to use only 2CPU?
June 8, 2012 at 12:29 am
i have gotten my answer from MS SQL forums based on this thread:
Basically, the number of processor license required depends on the number of CPU which the operating system has detected.
And, processor affinity is defintely out of scope.
June 8, 2012 at 1:00 am
You say you have gotten authorisation for 2 processor licenses, 2012 is core based so you need to purchase 8 core licenses to cover your upgrade if you remove the 2 processors to reduce the processing power in the server
June 12, 2012 at 3:34 pm
Is there a particular reason you are going to Per-core licensing? Unless your ability to count devices/clients connecting has changed, or you have crossed the break even barrier on CALs vs Core licensing, or you are using Enterprise Edition, it may be worth your while to stay with Server/CAL Licenses.
The break even for 2x4 Core procs vs Server CALs is about 65 CALs. i.e. if you have more than 65 CALs on an 8 core server, it's probably worth your while to go to Per Core Licensing.
For 4x4 core procs the break even is just over 130 CALS.
Hope this helps you make an informed decission.
Cheers
Leo
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
June 13, 2012 at 12:13 pm
Conray (6/7/2012)
Hi everyone,My organization has a plan to upgrade current SQL Server version from 2005 to 2012.
We will be using the same physical server for the upgrade.
At the same time, we intend to upgrade the OS version from Windows Server 2003 to Windows Server 2008 R2.
Server Spec:
Model: HP ProLiant DL580 G5
CPU: Intel(R) Xeon(R) CPU E7320 @ 2.13GHz (4x Quad Core)
RAM: 12GB
We will not be getting another server to perform the upgrade, so we will be formatting the current server to do the upgrade.
Here is the situation:
Currently we are on Server + CAL license, and we will be switching to Processor License.
On Processor license, due to budget contraints, we have only gotten 2 Processor License, that means we will downgrade from 4CPU to 2CPU.
My question is, will we still be able to use the same server (4CPU) but configure Processor Affinity in SQL to use only 2CPU?
Sql 2012 on old hardware (16 cores)... hmm.....
for enterprise edition, that's around $109k. a new 2-way machine using E5-2643's (quad core) should provide more computing horsepower than your existing hw for $54k less in licensing cost.
for standard edition, the numbers are closer. 16 cores for standard will run around 26k. Going to a faster machine with only 8 cores gives you 13k to spend on hardware.
so, I'd question why you wouldn't buy new HW.
Depending on your performance needs, you may be able to save money by getting newer HW with fewer cores.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply