+ Post New Thread
Results 1 to 5 of 5
Windows Server 2008 R2 Thread, SQL Server - running slow since putting more memory in! in Technical; Hi guys, Boss recently put more memory in the SQL server. Upped it from 8GB to 16GB. Since then it's ...
  1. #1
    Sam_Brown's Avatar
    Join Date
    Sep 2009
    Location
    Northampton
    Posts
    564
    Thank Post
    94
    Thanked 37 Times in 35 Posts
    Rep Power
    18

    SQL Server - running slow since putting more memory in!

    Hi guys,

    Boss recently put more memory in the SQL server. Upped it from 8GB to 16GB. Since then it's been running incredibly slowly

    Looking at performance and there is only 56MB memory free (1GB available though). SQL server is taking up over 15GB and other normal processes are taking up the rest.

    I am assuming this isn't normal behaviour?!?!

    If not best way to fix it as the boss is currently away.

    34zluza.png
    Last edited by Sam_Brown; 3rd November 2011 at 01:32 PM.

  2. #2

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,808
    Thank Post
    272
    Thanked 1,135 Times in 1,031 Posts
    Rep Power
    349
    There is an option in SQL to set the max amount of Ram the SQL process can use. Otherwise it will use as much of the ram as possible.

    Take a look at this guide > How to adjust memory usage by using configuration options in SQL Server

  3. #3

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,262
    Thank Post
    242
    Thanked 1,568 Times in 1,250 Posts
    Rep Power
    340
    Was the memory installed the same spec and timings or better? In servers you should stick to the same make of memory too.

    Are you running the latest SQL updates? I'm guessing you're running SQL 2008 R2?

  4. #4

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    15,938
    Thank Post
    886
    Thanked 1,693 Times in 1,472 Posts
    Blog Entries
    12
    Rep Power
    447
    SQL will keep eating as much RAM as you throw at it. I would do as on the link in post 2

  5. #5

    glennda's Avatar
    Join Date
    Jun 2009
    Location
    Sussex
    Posts
    7,808
    Thank Post
    272
    Thanked 1,135 Times in 1,031 Posts
    Rep Power
    349
    Another thing to bear in mind - how big is the sql database? If you are going to try and restrict the RAM it uses try and make sure that the process has a similar amount of ram to db size.

    This isn't always possible if its a huge db but if smaller then you should be ok

SHARE:
+ Post New Thread

Similar Threads

  1. SQL Server Express 2005 Memory Limit per instance?
    By localzuk in forum Windows Server 2000/2003
    Replies: 1
    Last Post: 30th April 2010, 01:27 PM
  2. Internet speed slow - since moving to server
    By flashsnaps in forum Windows
    Replies: 13
    Last Post: 25th November 2008, 11:44 AM
  3. Replies: 3
    Last Post: 7th July 2006, 02:21 PM
  4. SQL Server
    By wesleyw in forum Windows
    Replies: 5
    Last Post: 28th June 2006, 08:42 AM
  5. sql server
    By chrbb in forum Windows
    Replies: 17
    Last Post: 18th January 2006, 11:23 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
  •