| Author |
Topic |
|
schinni
Yak Posting Veteran
66 Posts |
 Posted - 2004-07-08 : 09:43:34
|
| Hello,We have a 4 way machine(Quad CPU) but we want to make sql server use two cpu's for thisto achieve should i go to processor tab under server properties check two CPU's right for examplewe have 0,1,2,3 should i check 2,3 and uncheck 0 and 1 and also under parllelisim should i change the that option to use 2 Processors instead of use all avaliable processors.I just wanted to see if i am missing something..Thanks |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-07-08 : 10:30:57
|
| That sounds about right. You may need a reboot after changes like those, or at least restart SQL server.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-08 : 13:16:33
|
| You shouldn't need to change the parallelism though. It will only use what's available to SQL Server.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
schinni
Yak Posting Veteran
66 Posts |
Posted - 2004-07-08 : 21:14:15
|
| Hello,On a 4 way machine since i am going to make sql server use only two cpu's can i only buy two processor license for sql server.Thanks, |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-08 : 23:59:28
|
| Microsoft reps themselves are confused about this if you ever ask them. The "letter of the law" states that you MUST license it for ALL processors that are accessible to any operating system with SQL Server installed. This means that if any instance on any machine or virtual machine is ran by an operating system that can access a processor, the processor must be licened. Basically, you would have to not use the processor at all.Now depending on your "interpretation", you might take a gamble. I wouldn't though because I don't like audits. :)MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-09 : 08:12:46
|
| What are the other two CPUs going to be doing?Kristen |
|
|
|
schinni
Yak Posting Veteran
66 Posts |
Posted - 2004-07-09 : 09:51:13
|
| Other two CPU's will be used by the Operating System and other applications like patrol etc other than sql server.. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-09 : 10:24:32
|
| Ah, OK, so its basically a dedicated SQL box. I was thinking you might say IIS or somesuch, to which the cheeky answer would have been to get two boxes, two CPUs each ...Kristen |
|
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-07-09 : 12:08:52
|
| If you've got (4) CPU's and it's basically a SQL server box, I say let SQL server use all four. Like Derrick says above, you have to license for how many physical CPU's are in the machine, not just what SQL server uses. This wording is nice for the Hyperthreaded CPU's. If you get (2) Hyperthreaded CPUs, Windows and SQL Server see (4) CPU's, but you only have to buy (2) SQL Processor licenses.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-07-09 : 12:56:26
|
| I agree with Michael about letting SQL Server using all 4 CPUs. The OS and other apps aren't going to use very much CPU, so why limit SQL Server to only 2 when the other two will mostly remain idle?Tara |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-09 : 13:07:22
|
I reckon the best bet is to pull the other two CPUs out and stick them in your Desktop Machine  |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-09 : 23:29:02
|
| I could use them if you want my address. I'll even pay the shipping.I know....I'm just a nice guy.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
Assiging CPU 's to Sql Server..