[sims] SQL using up a lot of RAM

[karls5]

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

[FN-GM]

Is someone running large/complex reports or maybe doing ctf files at that time? I have found that can hog resources.

[localzuk]

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?

[karls5]

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)

[karls5]

Can anything be done to Optimise perform?

[karls5]

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:

[localzuk]

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?

[karls5]

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.

[localzuk]

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.

[pete]

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

[glennda]

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.