Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I am running a website of off a small EC2 instance. The memory on the instance is maxed out, mostly due to SQL server process. I am thinking about either upgrading to a medium instance or staying with a small instance, but transfering the DB to RDS (with the new SQL server instance).

In terms of price, both options are more or less the same. In terms of scalability, going with RDS seems to be the better choice, since it will allow me to add more server on a load balacer, and feed them all off of the same RDS DB server.

On the other hand, communication between the DB and IIS machines might become an issue, and session, cache, authentication will become more complex (share machine key and the likes).

What information and data points should I consider when making this decision?

share|improve this question

1 Answer 1

up vote 2 down vote accepted

SQL Server uses all available memory by design. A better question will be what is that memory being used for? You can adjust the max memory via sp_configure:

sp_configure 'show advanced options', 1; 
GO 
RECONFIGURE; 
GO sp_configure 'max server memory', 1024; --Set to 1GB 
GO RECONFIGURE; 
GO

Then you'll need to restart the SQL Server process.

Are you seeing a significant amount of IO waits for queries? Is your memory being used to cache query plans for ad-hoc requests vs stored procs? Glenn Berry has some great basic tuning queries available at: http://sqlserverperformance.wordpress.com/2008/01/21/five-dmv-queries-that-will-make-you-a-superhero/

As for scaling on AWS, more memory means a higher potential buffer cache hit ratio, but leveraging RDS is simply abstracting out your log maintenance. You'll still see memory utilization and have to choose an instance size.

share|improve this answer
1  
I agree, and thank you for the extra info :) –  Elad Lachmi Jun 28 '12 at 16:54

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.