+ Post New Thread
Results 1 to 11 of 11
MIS Systems Thread, SQL using up a lot of RAM in Technical; Hi We are currently running Sims on Win 2008 64-bit with SQL 2008 virtually on Xenserver, we have 7GB of ...
  1. #1
    karls5's Avatar
    Join Date
    Jun 2010
    Location
    Northamptonshire
    Posts
    27
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    SQL using up a lot of RAM

    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

  2. #2

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,852
    Thank Post
    877
    Thanked 1,681 Times in 1,460 Posts
    Blog Entries
    12
    Rep Power
    445
    Is someone running large/complex reports or maybe doing ctf files at that time? I have found that can hog resources.

  3. #3

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,663
    Thank Post
    516
    Thanked 2,446 Times in 1,894 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
    As mentioned in the other thread:

    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?

  4. #4
    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)

  5. #5
    karls5's Avatar
    Join Date
    Jun 2010
    Location
    Northamptonshire
    Posts
    27
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Can anything be done to Optimise perform?

  6. #6
    karls5's Avatar
    Join Date
    Jun 2010
    Location
    Northamptonshire
    Posts
    27
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    A little more info on our setup, we are running 7 HP Blade server (Twin Quad core, 16GB Ram) across two HP C3000 Chassis connected directly to a HP MSA2000sa Storage array. All are running Xen server Sims is currently on its own blade. Our Sims server currently has two HDD of 70GB assigned to it With the OS on C: and Sql Data on E:

  7. #7

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,663
    Thank Post
    516
    Thanked 2,446 Times in 1,894 Posts
    Blog Entries
    24
    Rep Power
    831
    Your LDF files should not be that large. We have a 1.39Gb SIMS.mdf file (the actual database) and a 2Mb .ldf file (the transaction log).
    The FMS ones are 344Mb for the mdf and 10Mb for the ldf.

    The transaction log should be truncated each time you run a backup. How often are you running a proper SIMS.net backup?

  8. #8
    karls5's Avatar
    Join Date
    Jun 2010
    Location
    Northamptonshire
    Posts
    27
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    We just under 200 users, would that make a difference?

    Sinfo is set to run every night at 21:00 and and Backup Exec backup Mon to Fri to a NAS on our network.

  9. #9

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,663
    Thank Post
    516
    Thanked 2,446 Times in 1,894 Posts
    Blog Entries
    24
    Rep Power
    831
    Quote Originally Posted by karls5 View Post
    We just under 200 users, would that make a difference?

    Sinfo is set to run every night at 21:00 and and Backup Exec backup Mon to Fri to a NAS on our network.
    Not particularly. Sure, your ldf files should be larger than ours, but not that large.

  10. #10


    Join Date
    Dec 2005
    Location
    In the server room, with the lead pipe.
    Posts
    4,630
    Thank Post
    275
    Thanked 777 Times in 604 Posts
    Rep Power
    223
    What happens if you manually backup the database using SQL Management Studio?

    ++ on "your ldf should be nowhere near that big".

    We tell SQL (via a maintenance plan) to dump a full backup of all databases to local disk, where a scheduled task runs light compression on them and then copies them to the backup server.

    Currently, we're at 1.7GB mdf and about 32MB ldf

  11. #11

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,802
    Thank Post
    272
    Thanked 1,135 Times in 1,031 Posts
    Rep Power
    349
    Try Running a sims backup - this should then shrink the LDF - if not contact your support team as there a tool shrink the LDF files - found it yesterday. only applies to 2k8

    Our Sql service uses 6gb of ram and stores the entire database for both sims and fms in the ram.

SHARE:
+ Post New Thread

Similar Threads

  1. [For Sale] Dell PowerEdge 3250 4600 600SC RAM - PC2100 Registered Ram
    By FN-GM in forum Classified Adverts
    Replies: 0
    Last Post: 29th May 2011, 03:46 PM
  2. Our First Lot Of Honey !!
    By mattx in forum General Chat
    Replies: 42
    Last Post: 23rd August 2010, 08:49 AM
  3. Need a help (a lot of it lol)
    By mjt41 in forum EduGeek Joomla 1.5 Package
    Replies: 4
    Last Post: 23rd September 2009, 05:44 AM
  4. [Website] This explains a lot
    By somabc in forum Jokes/Interweb Things
    Replies: 1
    Last Post: 21st September 2009, 08:06 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
  •