When having problems with RAM on 2008 R2 and RamMap shows that this memory is being eaten by Mapped File do as fallows:
Use RAMmap to “Empty System Working Set” as needed. If you have this problem on daily basis go to second solution
I think this might, more or less, permanently solve the problem.
In any case you might need to upgrade server memory.
1) Install the management tools for SQL Server. You need sqlncli_x64.msi (for x64 Systems) and SQLServer2005_SQLCMD_x64.msi (for x64 Systems) both o this files cane be found here
2) Run the sqlcmd utility and change the config options.
c:\Program Files\Microsoft SQL Server\90\Tools\binn\SQLCMD.EXE -S -E \MICROSOFT##SSE ;
If above one does not work try this
c:\Program Files\Microsoft SQL Server\90\Tools\binn\SQLCMD.EXE -E -S \\.\pipe\MSSQL$MICROSOFT##SSEE \sql\query;
1> sp_configure ‘show advanced options’, 1
Configuration option ‘show advanced options’ changed from 0 to 1. Run the RECONFIGURE statement to install.
1> sp_configure ‘max server memory’, 512;
Configuration option ‘max server memory (MB)’ changed from 2147483647 to 512. Run the RECONFIGURE statement to install.