Post reply

Adding memory to SQL

  • April 7, 2015 at 5:09 pm

    #316414

    Hello,

    We have a SQL Server 2008 R2 standard edition server. The server has 8 GB RAM. SQL has 5GB.

    We want to add 4 GB to SQL.

    First we're going to add to the server. Once that's done we'll configure SQL with 9 GB. Adding memory via SSMS is pretty straight forward. Is there a need to restart SQL Server?

    If we were reducing I'd do it, but adding? Anything else to consider?

    Any comments would be appreciated - thanks.

  • April 7, 2015 at 5:42 pm

    #1789372

    If your server supports it you can add memory without restarting.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

  • April 8, 2015 at 6:58 am

    #1789511

    I assume you have the max server memory option set in SQL server to 5GB. So as mentioned above providing your server supports adding RAM without rebooting the server you just reconfigure the MAX server memory setting in SQL once it has been added:

    sp_configure 'show advanced options', 1;

    GO

    RECONFIGURE;

    GO

    sp_configure 'max server memory', 9216;

    GO

    RECONFIGURE;

    GO

    MCITP SQL 2005, MCSA SQL 2012

  • April 8, 2015 at 7:19 am

    #1789524

    Be sure your server doesn't support adding memory by restarting itself if you go down that route 🙂

Viewing 4 posts - 1 through 3 (of 3 total)

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