+ Post New Thread
Results 1 to 10 of 10
Windows Server 2012 Thread, Need to limit the ram used by SQL server 2012 getting slow down of sql 2008 due to ra in Technical; Hi all Can someone tell me if I can limit the amount of ram that is used by sql server ...
  1. #1
    round2it's Avatar
    Join Date
    May 2009
    Location
    UK
    Posts
    1,015
    Thank Post
    199
    Thanked 148 Times in 105 Posts
    Rep Power
    38

    Need to limit the ram used by SQL server 2012 getting slow down of sql 2008 due to ra

    Hi all

    Can someone tell me if I can limit the amount of ram that is used by sql server 2012 as I have a Library database on sql 2008 on the same server this is now running like a dog and eventually packs in.

    I need to stop and start the sql 2008 instance then it works again for a while.

    on server 2012
    Sims/FMS/Discover/solus3 on the sql 2012 instance

    Eclipse.net is running on the 2008 instance (support say i can not move to 2012)

    The server is running at 90% ram usage (expected)

    got more ram coming but I will be in the same boat once sql 2012 gets its hands on it.

    This problem only happened once sims was migrated to sql 2012 as it was on sql 2008 with no slow downs.

    any ideas.

  2. #2

    3s-gtech's Avatar
    Join Date
    Mar 2009
    Location
    Wales
    Posts
    2,817
    Thank Post
    146
    Thanked 571 Times in 515 Posts
    Rep Power
    154
    Yes you can do this - from within SQL Management Studio you can set maximum and minimum RAM usage (we do both, as it makes a big difference to SIMS performance).

  3. Thanks to 3s-gtech from:

    round2it (12th March 2014)

  4. #3
    round2it's Avatar
    Join Date
    May 2009
    Location
    UK
    Posts
    1,015
    Thank Post
    199
    Thanked 148 Times in 105 Posts
    Rep Power
    38
    can you eloborate on this process

    i was looking at resource pools
    is this the correct area in sql 2008
    Last edited by round2it; 11th March 2014 at 05:58 PM.

  5. #4
    round2it's Avatar
    Join Date
    May 2009
    Location
    UK
    Posts
    1,015
    Thank Post
    199
    Thanked 148 Times in 105 Posts
    Rep Power
    38
    If i can ask what spec is your sims server. As ours only has 8gig currently just ordered 32gig so this could help
    Ours is quad core opteron just running sims fms discover solus 3 and eclipse database and eclipse front end via iis.

    Update...
    Ok found the option in sql 2012
    What would be a good maximum for sims/fms/discover

    Really need this ram to turn up.
    Last edited by round2it; 11th March 2014 at 05:58 PM.

  6. #5
    Marshall_IT's Avatar
    Join Date
    Jul 2011
    Location
    Leeds
    Posts
    509
    Thank Post
    77
    Thanked 63 Times in 54 Posts
    Blog Entries
    1
    Rep Power
    19
    I'm just about to have sims installed with intouch and hosted slg link. I'd also really like to know people's server specs as well any other optimizations people have run.

  7. #6

    3s-gtech's Avatar
    Join Date
    Mar 2009
    Location
    Wales
    Posts
    2,817
    Thank Post
    146
    Thanked 571 Times in 515 Posts
    Rep Power
    154
    I have 32GB in the server, something like 20GB minimum RAM for SQL and maximum 26GB (or thereabouts). There are a few things in there as it's a VM with too little pagefile space on the disks, but it's quick enough. That has two quad core Opterons inside. Running SIMS, Discover, FMS, SOLUS3.

  8. Thanks to 3s-gtech from:

    round2it (11th March 2014)

  9. #7
    round2it's Avatar
    Join Date
    May 2009
    Location
    UK
    Posts
    1,015
    Thank Post
    199
    Thanked 148 Times in 105 Posts
    Rep Power
    38
    Thanks for that

    What amount of ram do you allocate to sql

  10. #8

    3s-gtech's Avatar
    Join Date
    Mar 2009
    Location
    Wales
    Posts
    2,817
    Thank Post
    146
    Thanked 571 Times in 515 Posts
    Rep Power
    154
    Looking at the server today - minimum 16GB, maximum 26GB.

  11. Thanks to 3s-gtech from:

    round2it (12th March 2014)

  12. #9
    round2it's Avatar
    Join Date
    May 2009
    Location
    UK
    Posts
    1,015
    Thank Post
    199
    Thanked 148 Times in 105 Posts
    Rep Power
    38
    anyone else like to post sql ram settings

  13. #10

    Join Date
    Apr 2009
    Location
    Essex
    Posts
    66
    Thank Post
    7
    Thanked 8 Times in 7 Posts
    Rep Power
    13
    Top of my head, Log into management studio to the instance you wish to assign a RAM limit to > Right click the very top of the tree (Servername\Instance) and properties > Should be a tab for memory. Doesn't take effect until a full server reboot.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 0
    Last Post: 15th April 2013, 12:15 PM
  2. Microsoft releases SQL Server 2012
    By Arthur in forum IT News
    Replies: 1
    Last Post: 12th March 2012, 09:36 AM
  3. Replies: 5
    Last Post: 6th November 2010, 07:20 AM
  4. Replies: 0
    Last Post: 2nd September 2010, 01:48 PM
  5. Replies: 24
    Last Post: 6th September 2005, 12:26 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •