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 ...
12th November 2010, 11:18 AM #1
SQL using up a lot of RAM
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
IDG Tech News
12th November 2010, 11:27 AM #2
Is someone running large/complex reports or maybe doing ctf files at that time? I have found that can hog resources.
12th November 2010, 11:28 AM #3
As mentioned in the other thread:
Originally Posted by karls5
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?
12th November 2010, 11:46 AM #4
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)
12th November 2010, 11:48 AM #5
Can anything be done to Optimise perform?
12th November 2010, 11:55 AM #6
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:
12th November 2010, 12:13 PM #7
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?
12th November 2010, 12:19 PM #8
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.
12th November 2010, 12:24 PM #9
Not particularly. Sure, your ldf files should be larger than ours, but not that large.
Originally Posted by karls5
12th November 2010, 01:00 PM #10
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
12th November 2010, 01:27 PM #11
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.
By FN-GM in forum Classified Adverts
Last Post: 29th May 2011, 04:46 PM
By mattx in forum General Chat
Last Post: 23rd August 2010, 09:49 AM
By mjt41 in forum EduGeek Joomla 1.5 Package
Last Post: 23rd September 2009, 06:44 AM
By somabc in forum Jokes/Interweb Things
Last Post: 21st September 2009, 09:06 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)