September 24, 2010 at 1:57 am
Hi
I have a badly treated SQL server running a useless software package - the software has been struggling for quite some time now and the only way I can get the software to work is to continiually change the maximum server memory on SQL.
I understand that this is bad practice but its kept the server going for several months now..... until yesterday!
I'm now receiving this error message when trying to change the memory levels and the allocated memory is not moving
---Alter Failed. (Microsoft.SqlServer.Smo)
Additional Information:
---An exception occured while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
-----Address Windows Extensions (AWE) requires the 'lock pages in memory' privilege which is not currently present in the access token of the process. (Microsoft SQL Server, Error: 5845)
Can anyone offer me any helpful advice - hopefully not run away!
Thanks
Craig Henderson
September 24, 2010 at 6:38 am
Lock pages in memory privilege is a must for AWE. Please refer this on how to grant this privilege.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
September 24, 2010 at 7:09 am
My bad! AWE shouldn't have been on!
Must have clicked it by mistake and hadn't noticed - doh
Thanks anyway
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply