Netstore
asked on
SQL 2005 running slow - AWE memory?
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?
Cheers
Si
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?
Cheers
Si
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The LOCK PAGE IN MEMORY permission must be granted to the SQL Server account before enabling AWE. For more information, see How to: Enable the Lock Pages in Memory Option (Windows).