We have a SQL database that seems to be gradually getting worse - I've done the usual things - profiling index etc looking at the memory it appears to stay at 1.6GB and this may (?) be the problem. The server has 8GB has /PAE set in the boot options.
However when I try to tick Enable AWE memory in server properties I get a failure with "Requires lock memory permissions".
1. Can this be done on the fly or do I need to get users out?
2. If it can be done - how do I do it?
3. Any other potential area's to look at on the server config?