July 13, 2012 at 7:32 am
Nakul Vachhrajani (7/13/2012)
The maximum supported number of logical processors by SQL Server 2008 R2 is 256 logical processors (which is a limit in-turn imposed by the operating system - Windows Server 2008 R2 Data Center edition - http://www.microsoft.com/en-us/server-cloud/windows-server/2008-r2-datacenter.aspx). Considering 2 logical processors/core, the correct answer is: 128 cores.
But a core does not *have* to include more than a single logical processor. If you have only 1 logical processor per core, then the answer 256 cores is correct (for the particular OS the OP was thinking of, anyway), and since he asked what was the *maximum* number of cores supported, then that is the correct answer. 128 cores cannot be the *maximum* number of supported cores when there's a situation when you can have more, after all!
July 13, 2012 at 7:39 am
paul.knibbs (7/13/2012)
Nakul Vachhrajani (7/13/2012)
The maximum supported number of logical processors by SQL Server 2008 R2 is 256 logical processors (which is a limit in-turn imposed by the operating system - Windows Server 2008 R2 Data Center edition - http://www.microsoft.com/en-us/server-cloud/windows-server/2008-r2-datacenter.aspx). Considering 2 logical processors/core, the correct answer is: 128 cores.
But a core does not *have* to include more than a single logical processor. If you have only 1 logical processor per core, then the answer 256 cores is correct (for the particular OS the OP was thinking of, anyway), and since he asked what was the *maximum* number of cores supported, then that is the correct answer. 128 cores cannot be the *maximum* number of supported cores when there's a situation when you can have more, after all!
That's why I mentioned "Considering 2 logical processors/core, the correct answer is: 128 cores", and that "OS Maximum is the correct answer in my humble opinion.
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
July 13, 2012 at 8:52 am
Nakul Vachhrajani (7/13/2012)
paul.knibbs (7/13/2012)
Nakul Vachhrajani (7/13/2012)
The maximum supported number of logical processors by SQL Server 2008 R2 is 256 logical processors (which is a limit in-turn imposed by the operating system - Windows Server 2008 R2 Data Center edition - http://www.microsoft.com/en-us/server-cloud/windows-server/2008-r2-datacenter.aspx). Considering 2 logical processors/core, the correct answer is: 128 cores.
But a core does not *have* to include more than a single logical processor. If you have only 1 logical processor per core, then the answer 256 cores is correct (for the particular OS the OP was thinking of, anyway), and since he asked what was the *maximum* number of cores supported, then that is the correct answer. 128 cores cannot be the *maximum* number of supported cores when there's a situation when you can have more, after all!
That's why I mentioned "Considering 2 logical processors/core, the correct answer is: 128 cores", and that "OS Maximum is the correct answer in my humble opinion.
+1
July 13, 2012 at 8:55 am
I agree! If you want the max number of logical cores, state that specifically in the question.
This is the biggest reason I don't bother answering these questions. Unclear, unspecific, vague questions with MS 'out of the book' answers. These people don't live/work in the real world.
I wish I had time to sit around and dream this stuff up.
July 13, 2012 at 9:28 am
mbova407 (7/13/2012)
Rich Weissler (7/13/2012)
So the correct answer is the Operating System limit.Presumably, if I were to load SQL 2008 R2 Data Center Edition on Windows Server 2012... it would be able to use 640 logical processors?
Can I pick none of the above?
Amen.
Sorry OP, not the best question
+1
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 13, 2012 at 9:53 am
Lynn Pettis (7/12/2012)
Although I got it correct, I think the true correct answer should have been Operating System Maximium. This would have taken the version of the OS out of the question.
+1
July 13, 2012 at 10:36 am
Once again we are down to the process whereby questions are vetted and approved or disapproved for publication. This must be improved.
Kenneth Spencer
You never know: reading my book: "All about your computer" might just tell you something you never knew!
lulu.com/kaspencer
July 13, 2012 at 10:51 am
SQLRNNR (7/13/2012)
mbova407 (7/13/2012)
Rich Weissler (7/13/2012)
So the correct answer is the Operating System limit.Presumably, if I were to load SQL 2008 R2 Data Center Edition on Windows Server 2012... it would be able to use 640 logical processors?
Can I pick none of the above?
Amen.
Sorry OP, not the best question
+1
+1 more
July 13, 2012 at 11:08 am
The wording of the question mentioned 'maximum processor cores' and BOL specified Operating System Maximum for SQL Server 2008 R2 Datacenter Edition. I looked up the specs of Windows Server 2008 R2 Datacenter and came to 256 logical processor capacity limit, assuming that this edition of Windows Server would provide the largest processor capacity. What did cause me hesitation was whether processor core is equivalent to logical processor.
- Ken Garrett
July 13, 2012 at 11:38 am
Ken Garrett (7/13/2012)
The wording of the question mentioned 'maximum processor cores' and BOL specified Operating System Maximum for SQL Server 2008 R2 Datacenter Edition. I looked up the specs of Windows Server 2008 R2 Datacenter and came to 256 logical processor capacity limit, assuming that this edition of Windows Server would provide the largest processor capacity. What did cause me hesitation was whether processor core is equivalent to logical processor.- Ken Garrett
It will get simpler yet more complicated, soon. 😉
In the upcoming WinServer 2012 you will not deal with physical and logical processors but with nodes, which is one process-executing unit, and that's all you need to know. Presumably.
July 13, 2012 at 12:00 pm
kaspencer (7/13/2012)
Once again we are down to the process whereby questions are vetted and approved or disapproved for publication. This must be improved.Kenneth Spencer
Are you volunteering to do this and if so for how long?
July 13, 2012 at 12:08 pm
Lynn Pettis (7/13/2012)
kaspencer (7/13/2012)
Once again we are down to the process whereby questions are vetted and approved or disapproved for publication. This must be improved.Kenneth Spencer
Are you volunteering to do this and if so for how long?
+1
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
July 16, 2012 at 2:25 am
I agree with the majority on this discussion. This is a SQL forum, and the "SQL" response to this question is "The Operating System Maximum". 256 is the answer to "How many processors are supported by Windows Server 2008 R2 Datacenter x64 edition".
Windows Server 2012 is in RC Preview http://technet.microsoft.com/en-gb/evalcenter/hh670538.aspx?ocid=&wt.mc_id=TEC_108_1_33
If you were so inclined you could buy a massive server, download the RC and install SQL 2008 R2 just to prove the answer to this question incorrect. (Clearly I guessed the answer to this question incorrectly also) 🙂
July 16, 2012 at 6:51 am
Thanks for the question.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 16, 2012 at 1:45 pm
Revenant (7/13/2012)
SQLRNNR (7/13/2012)
mbova407 (7/13/2012)
Rich Weissler (7/13/2012)
So the correct answer is the Operating System limit.Presumably, if I were to load SQL 2008 R2 Data Center Edition on Windows Server 2012... it would be able to use 640 logical processors?
Can I pick none of the above?
Amen.
Sorry OP, not the best question
+1
+1 more
Still +1 more.
Viewing 15 posts - 16 through 30 (of 32 total)
You must be logged in to reply to this topic. Login to reply