Windows Server 2000/2003 Thread, SQL 2005 Edition in Technical; I have a server that has 4GB of RAM. What happens is that every so often I'll find the RAM ...
6th July 2009, 01:43 PM #1
SQL 2005 Edition
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?
6th July 2009, 01:54 PM #2
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.'
6th July 2009, 02:07 PM #3
How can I get to the SQL instance to alter this?
Originally Posted by IanT
By Heebeejeebee in forum MIS Systems
Last Post: 7th April 2009, 03:19 PM
By cheredenine in forum MIS Systems
Last Post: 19th December 2008, 06:42 PM
By tom_newton in forum Windows
Last Post: 23rd January 2008, 05:10 PM
By jcollings in forum MIS Systems
Last Post: 22nd October 2007, 03:00 PM
By dezt in forum MIS Systems
Last Post: 26th September 2007, 10:40 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)