SQL Server - running slow since putting more memory in!

[Sam_Brown]

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.

 

Edited November 3, 2011 by Sam_Brown

[glennda]

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

[Michael]

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?

[FN-GM]

SQL will keep eating as much RAM as you throw at it. I would do as on the link in post 2

[glennda]

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