Friday, 13 September 2013

Lock Pages in Memory keep SQL database engine stuck at allocating 60MB ram?

Lock Pages in Memory keep SQL database engine stuck at allocating 60MB ram?

I'm using Window Server 2003 Enterprise. Microsoft SQL Server 2005
Standard Edition.
The problem is the SQL server memory always stuck at allocating 1.7GB ram
max even i have 11GB ram left.
According to this thread, which the thread starter have them same issues:
http://www.sqlservercentral.com/Forums/Topic499500-146-1.aspx#bm499829 . I
tried adding /APE to my boot.ini, add the network service account which is
running sqlserv.exe to Lock Pages in Memory option. And reconfigure SQL
use AWE to allocate memory.
But i have no lucky, after restart the server. The SQL database engine
cannot allocating more than 60MB ram. Which is terrible failure as my
expected.
So after that, i must to restore my setting - remove the network service
account from Lock Pages in Memory option, restart my server and it come
back to the first problem. The SQL server database engine always stuck at
allocating 1.7GB ram. So the Lock Pages in Memory keep SQL database engine
stuck at allocating 60MB ram ? And how to resolve the first problem now ?

No comments:

Post a Comment