SQL Server maximum Server Memory

  • I am using SQL Server 2008 R2  Express  edition. I have already set Maximum Server memory to 2Gb.

    Is there any benefit if I Change it from 2Gb to 3Gb?

  • That rather depends on the amount of memory your machine has and what else is running.

    Incidentally SQL 2008 R2 is out of extended support so you may want to upgrade to a more recent version to get security patches.

     

  • no benefit - Express will use a maximum of 1 GB for database engine

    https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/cc645993(v=sql.105)?redirectedfrom=MSDN

  • Get the Developer Edition, that would allow you to use more RAM and give you many other added capabilities as well.

    SQL DBA,SQL Server MVP(07, 08, 09) Prosecutor James Blackburn, in closing argument in the Fatal Vision murders trial: "If in the future, you should cry a tear, cry one for them [the murder victims]. If in the future, you should say a prayer, say one for them. And if in the future, you should light a candle, light one for them."

  • Just be careful what you use the Developers Edition for.  If the databases on your SQL Express system are production databases in any way, shape, or form, it's a flagrant license violation to use the Developers Edition for such a thing.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    "Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Jeff Moden wrote:

    Just be careful what you use the Developers Edition for.  If the databases on your SQL Express system are production databases in any way, shape, or form, it's a flagrant license violation to use the Developers Edition for such a thing.

    This. So very much this.

    The Developers Edition is excellent and a useful tool... for development and testing. It can't be used in any kind of production capacity.

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

Viewing 6 posts - 1 through 6 (of 6 total)

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