Memory

  • Chandra Sekhara Vyas Dhara

    SSChampion

    Points: 10207

    Comments posted to this topic are about the item Memory

  • Shiva N

    Hall of Fame

    Points: 3125

    Nice Question...

    Thanks,
    Shiva N
    Database Consultant

  • Jo Pattyn

    SSC-Dedicated

    Points: 31258

    Could you rephrase it to What is the recommended minimum memory requirement ...?

  • Rune Bivrin

    SSCertifiable

    Points: 7499

    Minimum:

    Express Editions: 512 MB

    All other editions: 1 GB

    Recommended:

    Express Editions: 1 GB

    All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance.

    Since the question didn't specify Express Edition there's really no answer that's completely correct.


    Just because you're right doesn't mean everybody else is wrong.

  • ksatpute123

    Hall of Fame

    Points: 3325

    Rune Bivrin (11/14/2014)


    Minimum:

    Express Editions: 512 MB

    All other editions: 1 GB

    Recommended:

    Express Editions: 1 GB

    All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance.

    Since the question didn't specify Express Edition there's really no answer that's completely correct.

    +1

  • ksatpute123

    Hall of Fame

    Points: 3325

    Once again an example of badly phrased question. Makes me think that an option to rephrase or un-publish should be provided.

  • peter.row

    SSCarpal Tunnel

    Points: 4284

    +1 to the badly phrased question.

    I put none of the above because as with most things with SQL it depends.

    With the cost of RAM these days I would never run any computer (let alone one used for SQL) with less than 4GB of RAM, hell my current Dell work machine has 16GB.

  • This was removed by the editor as SPAM

  • paul.knibbs

    SSCoach

    Points: 15270

    Yeah, I also put "none of the above" because of the 4Gb recommended minimum for non-Express editions.

  • kaspencer

    SSCarpal Tunnel

    Points: 4190

    What a ridiculous answer!

    No edition was stated! If 1Gbyte was correct then so also was 4Gbyte.

    I think that once again, the moderators are asleep on the job!

    In frustration and annoyance

    Kenneth Spencer

    You never know: reading my book: "All about your computer" might just tell you something you never knew!
    lulu.com/kaspencer

  • Mike Hays

    SSCommitted

    Points: 1871

    If you asked the question: "What is recommended memory requirement for SQL Server 2012?",

    why is the link that you provided go to the web page titled "Hardware and Software Requirements for Installing SQL Server 2014"?

  • Grant Fritchey

    SSC Guru

    Points: 395264

    Gotta agree. Without an edition being stated, the answers change. Just saying SQL Server, I would assume the full product, then the minimum is 1gb, but the recommended is 4gb. And you used recommended on purpose to avoid the easy minimums answer.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
    Theodore Roosevelt

    The Scary DBA
    Author of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • rupert.hirst

    SSC Rookie

    Points: 44

    Hi, its a misleading question - it asks for the recommended amount of memory, not the minimum - so the recommended amount would depend on the application requirements, so none of the above.....

  • batgirl

    SSCarpal Tunnel

    Points: 4979

    Jo Pattyn (11/14/2014)


    Could you rephrase it to What is the recommended minimum memory requirement ...?

    The way I see it, "requirement" and "recommended" don't belong together.

    There is a minimum requirement.

    And then there is a minimum recommendation.

  • gordon.feeney

    SSC Enthusiast

    Points: 186

    I'm agreement with others that the question ought to have been 'recommended minimum memory', hence my incorrect answer of 'none of the above'.

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

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