I have a poorly 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! Financial constraints mean this is the only solution for me at the moment :(
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)
---An exception occured while executing a Transact-SQL statement or batch.
-----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!
View Complete Post