+ Post New Thread
Results 1 to 3 of 3
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 ...
  1. #1

    Join Date
    Jun 2008
    Posts
    719
    Thank Post
    118
    Thanked 64 Times in 52 Posts
    Rep Power
    31

    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?

  2. #2
    IanT's Avatar
    Join Date
    Aug 2008
    Location
    @ the back of my server racks farting.....
    Posts
    1,891
    Thank Post
    2
    Thanked 118 Times in 109 Posts
    Rep Power
    60
    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.'

  3. #3

    Join Date
    Jun 2008
    Posts
    719
    Thank Post
    118
    Thanked 64 Times in 52 Posts
    Rep Power
    31
    Quote Originally Posted by IanT View Post
    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?

SHARE:
+ Post New Thread

Similar Threads

  1. Install SQL 2005 Full over 2005 Express (other instances)
    By Heebeejeebee in forum MIS Systems
    Replies: 4
    Last Post: 7th April 2009, 03:19 PM
  2. Serco Facility and MS SQL server Express edition
    By cheredenine in forum MIS Systems
    Replies: 19
    Last Post: 19th December 2008, 06:42 PM
  3. MS SQL 2005 - Dump SQL
    By tom_newton in forum Windows
    Replies: 7
    Last Post: 23rd January 2008, 05:10 PM
  4. SQL 2005
    By jcollings in forum MIS Systems
    Replies: 12
    Last Post: 22nd October 2007, 03:00 PM
  5. Question about sql 2005
    By dezt in forum MIS Systems
    Replies: 11
    Last Post: 26th September 2007, 10:40 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •