SQL 2005 Edition

[Chuckster]

I have a server that has 4GB of RAM. What happens is that every so often I'll find the RAM usage dropping considerably low and at one time I found it to have 50MB free left. I've noticed that the sqlservr.exe is the main culprit and usually sucks up what ever available memory there is.

 

Is there a way I can combat this? On the server there is a piece of software that monitors students yearly progression and WSUS. What can I do to prevent the sqlservr.exe from carrying on like this?

[IanT]

This sounds normal. SQL Server will use most available RAM in the normal course of operation and rarely gives that memory back to the OS.

 

Install latest service pack etc or Right-click on the instance of SQL Server in question, choose 'Properties,' choose 'Memory,' change 'Maximum Server Memory.'

[Chuckster]

This sounds normal. SQL Server will use most available RAM in the normal course of operation and rarely gives that memory back to the OS.

 

Install latest service pack etc or Right-click on the instance of SQL Server in question, choose 'Properties,' choose 'Memory,' change 'Maximum Server Memory.'

 

How can I get to the SQL instance to alter this?