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