Post reply

How do I give SQL Server 2008 R2 More Ram?

  • July 31, 2011 at 7:27 pm

    #240988

    I am running Windows 2008 R2 web server. How do I allot SQL Server 2008 R2 more ram? Where do I go to do this...if I can.

  • August 1, 2011 at 4:50 am

    #1361433

    By default SQL Server will consume all the memory it wants and is available. Unless you've changed this default you dont need to do any more.

    You can run the following (setting your own values), this will override the defaults and in many respects is preffered to ensure optimal OS performance.

    EXEC sys.sp_configure N'min server memory (MB)', N'10'

    GO

    EXEC sys.sp_configure N'max server memory (MB)', N'300'

    GO

    RECONFIGURE WITH OVERRIDE

    GO

  • August 1, 2011 at 5:21 am

    #1361442

    How much ram do you have on the machine now and why do you think sql server is starving on ram?

  • August 1, 2011 at 8:41 am

    #1361593

    Ninja's_RGR'us (8/1/2011)

    How much ram do you have on the machine now and why do you think sql server is starving on ram?

    I have a Virtual Private Server with 5 GB of Ram. My VPS has burstable Ram which is now up to a total of 4 GB. Finally, my site seems to be running OK. It kept locking up and I thought it was a SQL Server Ram issue. Now, that the SQL Server ram is up to a little over 1 GB, the sites seems to be running fine.

  • August 1, 2011 at 8:49 am

    #1361606

    I wouldn't bother too much about something where's it's working fine.

    I'd just make sure to not install too much stuff on the server so that ss is not competing with other appsfor the ram.

  • August 1, 2011 at 9:50 am

    #1361659

    Thanks SSC-Addicted...errr MysteryJimbo

  • August 1, 2011 at 10:09 am

    #1361679

    markpringle (8/1/2011)

    Thanks SSC-Addicted

    His name is MysteryJimbo. Addicted is based on his # of points on the site.

  • August 1, 2011 at 11:36 am

    #1361735

    His name is MysteryJimbo. Addicted is based on his # of points on the site.

    Thanks

  • August 2, 2011 at 12:53 am

    #1361962

    Ninja's_RGR'us (8/1/2011)

    markpringle (8/1/2011)

    Thanks SSC-Addicted

    His name is MysteryJimbo. Addicted is based on his # of points on the site.

    😀

  • August 2, 2011 at 1:28 am

    #1361965

    can you elaborate on what you mean by the server is locking? Do you mean no one can access it, its running dog slow etc etc?

    During this period have you been able to look at any of the dmv's to check for any blocking and in particular resource_semaphore wait types?

    _________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie

Viewing 10 posts - 1 through 9 (of 9 total)

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