Memory Usage control

[nowayout]

Hi All,

I have MSDE and it is using almost 1.04 g physical memory.. How Can i control it to 50% usage or at least 60% usage of physical memory.

Thanks

 

[JayKusch]

Open Enterprise Manager and then right-click on the server name. Choose Properties..Memory. In there you will be able to adjust the memory usage though it is best to let SQL Server handle the memory itself.

Thanks

J. Kusch

 

[mrdenny]

nowayout, If you have access to Enterprise Manager, then follow Jay's directions. If not use sp_configure to change the Max memory.

exec sp_configure 'max server memory (MB)', 512
reconfigure

Denny

--Anything is possible. All it takes is a little research. (Me)