Max processor cores

  • Comments posted to this topic are about the item Max processor cores

    Regards,
    Ravi.

  • I hate to say it but this is another one of those questions that is not quite clear enough. Is a processor core a logical processor or a processor?

    The same article that is quoted to contain the answer mentions that on Windows Server 2008 R2 (what if it is installed on another OS?) SQL 2008 R2 DC can use a maximum of 64 processors or 256 logical processors.

    So in this case I think both 64 and 256 should be accepted as correct.

    Cheers.

  • 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.

  • Lynn Pettis (7/12/2012)


    Although I got it correct, I think the true correct answer should have been Operating System Maximium.

    Indeed it should - according to BOL - http://msdn.microsoft.com/en-us/library/cc645993(v=sql.105).aspx

  • I'd agree OS max is the best response, but there is little ambiguity in terms of the fact that cores in the question definitely means logical processors.

  • This was removed by the editor as SPAM

  • Haaico (7/13/2012)


    I hate to say it but this is another one of those questions that is not quite clear enough. Is a processor core a logical processor or a processor?

    The same article that is quoted to contain the answer mentions that on Windows Server 2008 R2 (what if it is installed on another OS?) SQL 2008 R2 DC can use a maximum of 64 processors or 256 logical processors.

    So in this case I think both 64 and 256 should be accepted as correct.

    Cheers.

    There's a near-even split between the two answers, so you're not alone there!

    Good point on the OS too.

    I tend to read "core" as = "logical processor" automatically these days.

  • Thank you for the point.Too easy.

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

  • 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?

  • Haaico (7/12/2012)


    I hate to say it but this is another one of those questions that is not quite clear enough. Is a processor core a logical processor or a processor?

    The same article that is quoted to contain the answer mentions that on Windows Server 2008 R2 (what if it is installed on another OS?) SQL 2008 R2 DC can use a maximum of 64 processors or 256 logical processors.

    So in this case I think both 64 and 256 should be accepted as correct.

    Cheers.

    Core is a standard term. It refers to one or more distinct processing units within a CPU chip. If the question had used the term "processor" without qualification, you might have an argument. But you have to assume that core is used in a non-standard manner in order to choose 64.

  • 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

  • I believe that the correct answer to this question is the most popular answer in this community:

    It depends.

    Because it depends on the Operating System maximum.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • A logical processor is not the same as a core. A core can have 1 or 2 logical processors. Reference: TechNet: Computing Capacity Limits by Edition of Microsoft SQL Server

    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.

    The proposed correct answer (256 cores) is therefore incorrect because the question is talking about cores, not logical processors. OS maximum is a valid answer in my humble opinion.

    Thanks & Regards,
    Nakul Vachhrajani.
    http://nakulvachhrajani.com

    Follow me on
    Twitter: @sqltwins

  • Lynn Pettis (7/12/2012)


    Although I got it correct, I think the true correct answer should have been Operating System Maximum. This would have taken the version of the OS out of the question.

    I clicked to the question link, fully expecting Operating System Maximum to be one of the choices. As I don't know the limit for the operating system, I was forced to guess.

    I had to guess, as I work for a smallish company. For us, the correct answer is: However big a server we can buy with the meager budget grudgingly given by the bean counters. Product limitations do not matter much when you're on a budget. 😉

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • The worst part of the ambiguous question and answer is that if you wanted to test knowledge about the OS max then the OS should be specified. The "correct" answer will be wrong when a newer version of Windows comes out and supports more than 256 cores. Too bad we have another interpretation question.

    _______________________________________________________________

    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/

Viewing 15 posts - 1 through 15 (of 32 total)

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