Unable to set limited for MS sqlserver.exe high memory usage 2008 R2
HI,
we are unable to set the memory use limited for sql server exe.
we are running the JDE Enterprise server and database server (MS SQL SERVER 2008 R2 64 bit) on same box.
The sqlserver occupied almost all memory of system. Even i have set the limited for memory from sql server properties.
The SQ L Server still use the more memory as i set the limited.
GO
sp_configure 'show advanced options', 1;
output: onfiguration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
GO
RECONFIGURE;
ommand(s) completed successfully
GO
sp_configure 'max server memory', 40096;
GO