+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, What's your memory usage on your SIMS server? in Technical; Hi, Our memory usage on our SIMS server is behaving oddly, I was just wondering how much memory other schools ...
  1. #1

    Join Date
    Mar 2009
    Location
    Norton, N. Yorks
    Posts
    86
    Thank Post
    36
    Thanked 8 Times in 8 Posts
    Rep Power
    13

    What's your memory usage on your SIMS server?

    Hi,

    Our memory usage on our SIMS server is behaving oddly, I was just wondering how much memory other schools are using so I know if ours is normal or not.

    We have around 1,000 students, 150 staff, 10 servers and 480 computers.

    MIS server specs:

    Virtual server
    2 processors
    6GB RAM
    1 Gbps network connection

    Windows Server 2008 R2 Standard SP1
    SQL Server 2008 (fairly sure this is running SP2)

    CPU usage and network usage is low. However, the initial memory was 2GB, and the server used about 96% of this, so I bumped it up to 4GB and then 6GB. However, it's maxed out at 96% yet again. I'm wondering if it needs more, or if SQL server just utilizes what's available.

    What are other schools seeing, and how much memory are you using?

    Server has 71 process running, and SQL server is using 4.7GB of the 5.6GB used memory

    Regards,

    Daniel

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,480
    Thank Post
    372
    Thanked 657 Times in 537 Posts
    Rep Power
    162
    SQL will use whatever it can get normally. The Capita's rule is size of the database + 50% + OS (1gb).

  3. Thanks to matt40k from:

    d-taylor (24th September 2012)

  4. #3
    british_government's Avatar
    Join Date
    Feb 2009
    Posts
    160
    Thank Post
    24
    Thanked 20 Times in 15 Posts
    Rep Power
    36
    I read up on this recently, apparently it is normal for sql 2008 to just grab as much memory as is available. Seems strange to me.

    Thanks Matt for the tip on capita's rule

  5. #4

    jinnantonnixx's Avatar
    Join Date
    Mar 2011
    Location
    In the Calamatorium.
    Posts
    2,049
    Thank Post
    121
    Thanked 525 Times in 352 Posts
    Blog Entries
    2
    Rep Power
    295
    How to adjust memory usage by using configuration options in SQL Server

    The principle behind this is that it's better to make use of memory rather than have nothing in memory, so SQL will use what it finds available. SQL server will release memory on demand, down to its low limit. If you look at these values, you'll normally find them set to crazy values, which means it will use everything it can. Don't adjust these values unless you have a good reason.
    Last edited by jinnantonnixx; 24th September 2012 at 01:40 PM.

  6. Thanks to jinnantonnixx from:

    d-taylor (24th September 2012)

  7. #5

    Join Date
    Mar 2009
    Location
    Norton, N. Yorks
    Posts
    86
    Thank Post
    36
    Thanked 8 Times in 8 Posts
    Rep Power
    13
    Many thanks for the replies, glad there's nothing to worry about. My SIMS database is 2GB so following that rule 6GB is about right

    Daniel

  8. #6

    Join Date
    May 2011
    Location
    York
    Posts
    54
    Thank Post
    0
    Thanked 3 Times in 3 Posts
    Rep Power
    8
    My database is also alittle over 2 gb but ive got sims sql running on a Temporary server that has 64gb of ram and the SQL service is currently using 9gb which i find truely amazing that must be some serious duplication in memory!!



SHARE:
+ Post New Thread

Similar Threads

  1. Permissions on your simsroot/sims drive/s: drive
    By Oops_my_bad in forum MIS Systems
    Replies: 3
    Last Post: 30th August 2014, 10:41 PM
  2. [SIMS] Learning Gateway - what do you put on your front page
    By Oops_my_bad in forum MIS Systems
    Replies: 3
    Last Post: 5th December 2010, 10:59 AM
  3. What Anti Virus do you use on your home pc's?
    By tosca925 in forum General Chat
    Replies: 52
    Last Post: 5th June 2008, 06:11 PM
  4. What's On Your Stick
    By russdev in forum General Chat
    Replies: 19
    Last Post: 23rd January 2008, 10:50 AM
  5. what's on your stick
    By russdev in forum Hardware
    Replies: 23
    Last Post: 17th January 2008, 12:22 AM

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
  •