| Author |
 Topic  |
|
|
mary_itohan
Posting Yak Master
179 Posts |
 Posted - 07/08/2012 : 19:01:15
|
hello guys,
we are running a 24 core SERVER CPU, and due to licesnsing costs, we want to restrict the amount of CPU cores that will run sql server.
I have done a google search, but not totally satisfied with what I am seeing. So in EM, I clicked on the instance and choose properties. And Under Enable processors >> Automatically set processor affinity mask for all processors.
Which then enables the check boxes and I removed 5 out of 6.
Is this correct ? as if i click on properties, I still see 24 CPUs ???
please advise
many thanks
_____________________
Yes O ! |
|
|
robvolk
Most Valuable Yak
USA
15559 Posts |
Posted - 07/09/2012 : 07:16:21
|
| In order to properly comply with the license, the CPUs must be disabled or removed, setting the affinity mask is NOT sufficient. Check with your Microsoft licensing rep to be sure, they will answer any questions you have. (Call your local or regional Microsoft office) |
 |
|
|
jeffw8713
Aged Yak Warrior
USA
694 Posts |
Posted - 07/09/2012 : 14:00:48
|
Also be aware that SQL Server is licensed based on the number of sockets - not the cores. For processor licensing with 24 cores (4 hex core processors) you only need 4 processor licenses.
|
|
|
|
sarathi
Starting Member
India
2 Posts |
Posted - 07/16/2012 : 05:59:05
|
Are you using sql 2008?
In sql server 2008, we have option resource governor and using that you can restrict the CPU & memory for SQL server processeses
Regards
Vijayasarathi |
|
|
|
robvolk
Most Valuable Yak
USA
15559 Posts |
Posted - 07/16/2012 : 06:56:09
|
| Using Resource Governor won't affect the licensing requirements though. |
|
|
| |
Topic |
|
How do I restrict the amount of CPU on sql server
