+ Post New Thread
Page 1 of 2 12 LastLast
Results 1 to 15 of 16
MIS Systems Thread, SIMS SQL 2008 - How much memory do you have allocated? in Technical; Morning all, Done the SQL 2005 to SQL 2008 migration yesterday. Just wondering what kind of memory settings people use ...
  1. #1

    Join Date
    Jun 2010
    Posts
    384
    Thank Post
    35
    Thanked 56 Times in 53 Posts
    Rep Power
    32

    SIMS SQL 2008 - How much memory do you have allocated?

    Morning all,

    Done the SQL 2005 to SQL 2008 migration yesterday.

    Just wondering what kind of memory settings people use to get decent performance out of their server?

    SIMS is currenly running on a server 2003 standard OS which obvioulsy has all kinds of different memory settings such as PAE in boot.ini etc. I know we could do with upgrading to get better performance but we are moving to a new virtualised network in the summer of 2011 and therefore were trying to hang off buying a new server just for 6months use.

    I'm therefore wondering what kind of memory allocation people have for the server within the server properties option in SQL Management console? or has anyone any other "tricks" for getting better performance out of their server?

    Thanks

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,387
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Depends, how bigs the database, is the server just SIMS\SQL, how much RAM have you got.

  3. #3

    Join Date
    Jun 2010
    Posts
    384
    Thank Post
    35
    Thanked 56 Times in 53 Posts
    Rep Power
    32
    Hi Matt,

    Our database is only about 1.9GBs - there is 10GBs RAM in the server but obviously server 2003 standard doesnt make use of all that properly.

    edit* the server is also only used for SIMs nothing else
    Last edited by Max_Power; 27th October 2010 at 09:35 AM.

  4. #4

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,387
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Are you running server 2003 x64?

  5. #5

    Join Date
    Jun 2010
    Posts
    384
    Thank Post
    35
    Thanked 56 Times in 53 Posts
    Rep Power
    32
    Thats the problem, currently only running x32

  6. #6

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,387
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    You might as well remove 6gb worth of sticks and use them as chop sticks, you'll get more use out of them until you upgrade to x64\enterprise.

  7. #7
    AWicher's Avatar
    Join Date
    Nov 2008
    Location
    Preston
    Posts
    317
    Thank Post
    58
    Thanked 40 Times in 31 Posts
    Rep Power
    18
    I was debating if to post a constructive comment like that but restrained myself. So hats off to you, lol

  8. #8

    Join Date
    Jun 2010
    Posts
    384
    Thank Post
    35
    Thanked 56 Times in 53 Posts
    Rep Power
    32
    hahahaha just wonderful inheriting a network.

  9. #9

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,387
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Think going 64bit is really the only option, you could upgrade to enterprise, but I think that's just crooked. Once you've gone 64bit, you could enable AWE and set something stupid like 5GB min for SQL.

  10. #10

    Join Date
    Jun 2010
    Posts
    384
    Thank Post
    35
    Thanked 56 Times in 53 Posts
    Rep Power
    32
    I knew that was gonig to be the answer i would get - but to migrate to enterprise for just 6 months (which would actually be less by the time i can do the migration because school are back next week) it would be surely quite pointless?

    Ill just do it the right way in summer.

    Been in this "new" job a litte while now, but still finding little things like this every so often which makes life so much more difficult.

  11. #11

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Summer is 8 months away. You could install a "bad" virtualisation option like VMWare server onto the current server and then do a test install, see if you get better performance from it. Even switch to the virtualised version if it worked out better. Since you got 6GB doing nothing, might as well utilise it a little and split the CPU power.

    * I say "bad" in as much as it's installed on top of another OS rather then hyper-visored, i ran a few servers like that for a while, at least you get the benefits of things like snapshots to undo failed upgrades etc. Only 1 snapshot on VMWare server though, but at least its free.

  12. #12
    karls5's Avatar
    Join Date
    Jun 2010
    Location
    Northamptonshire
    Posts
    27
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hi

    We are currently running Sims on Win 2008 64-bit with SQL 2008 virtually on Xenserver, we have 7GB of Ram allocated and 8 cores set.

    We have a problem that Ram used max's out once a week or so resulting in the server hanging around 9am when when most staff will be logging on to sims. Have done a quick google this morning and saw AWE mentioned.

    How do you if this is already set? Don't know too much about the inner workings of SQL

    Thanks

  13. #13

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,652
    Thank Post
    516
    Thanked 2,443 Times in 1,891 Posts
    Blog Entries
    24
    Rep Power
    831
    Quote Originally Posted by karls5 View Post
    Hi

    We are currently running Sims on Win 2008 64-bit with SQL 2008 virtually on Xenserver, we have 7GB of Ram allocated and 8 cores set.

    We have a problem that Ram used max's out once a week or so resulting in the server hanging around 9am when when most staff will be logging on to sims. Have done a quick google this morning and saw AWE mentioned.

    How do you if this is already set? Don't know too much about the inner workings of SQL

    Thanks
    AWE is related to 32bit OS's, not 64bit as it is for enabling memory outside the 32bit OS's normal operating limits.

    What size is your SIMS database?

  14. #14
    karls5's Avatar
    Join Date
    Jun 2010
    Location
    Northamptonshire
    Posts
    27
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    According to the SQL Management Studio Sims is 14.5GB (ldf is 10GB and mdf 4.5) and FMS is 4.5GB (ldf 3.9 and mdf 600mb)

  15. #15

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Quote Originally Posted by karls5 View Post
    According to the SQL Management Studio Sims is 14.5GB (ldf is 10GB and mdf 4.5) and FMS is 4.5GB (ldf 3.9 and mdf 600mb)
    Whoa! That's huge. you need to get some advice and run some shrinkage tools. if the system manager backup doesn't shrink that ldf, then you might have to do it manually. same on FMS.

    Dealing with files that large can't be good, unless you really have that much data in the system constantly being accessed and updated. check out some of the other threads where jinnantonnix gives advice, or contact support.

SHARE:
+ Post New Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. How many Partitions do you have??
    By actech in forum Windows
    Replies: 31
    Last Post: 28th August 2011, 08:00 PM
  2. How amny printers do you have in school
    By rckngslnd in forum Network and Classroom Management
    Replies: 16
    Last Post: 3rd February 2011, 04:08 PM
  3. [Joke] So, How Much Tax Do You Pay?
    By DaveP in forum Jokes/Interweb Things
    Replies: 1
    Last Post: 17th March 2010, 12:15 PM
  4. Moodle users, how much storage do you need?
    By gshaw in forum Virtual Learning Platforms
    Replies: 5
    Last Post: 12th December 2008, 11:15 AM
  5. How much space do you give teachers?
    By sidewinder in forum General Chat
    Replies: 20
    Last Post: 10th October 2006, 10:58 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
  •