In this page : http://msdn.microsoft.com/en-us/library/ms143685%28v=sql.105%29.aspx It's written that SQL 2008R2 Standard supports 64GB of RAM, but is it per instance?

For SQL2012 (here : http://msdn.microsoft.com/fr-fr/library/cc645993.aspx ) it's written that it's "For a single instance", but not for 2008R2.

This question has already been asked (SQL Server 2008 R2 memory limit per instance or server?) but the answer comes from a test (and not with 64GB), so i'm not sure it will work for me :-)

The goal for me is to get a server with 128GB RAM, with two SQLSERVER2008R2STD, each with 64BG RAM (minus the OS-requiered).



Yes, it's per instance.

From the Server Memory Options page on TechNet:

Use max server memory to control memory usage. Establish maximum settings for each instance, being careful that the total allowance is not more than the total physical memory on your machine.

1st bullet under the Running Multiple Instances of SQL Server section toward the bottom.

  • Thanks for your answer! Yes I'll be careful and will keep a safety amount of RAM. – Patator Feb 11 '14 at 18:01

As every instance of SQL Server is a separate process, it's more logical that the limit is per instance.

Coordinating memory usage between different processes is something very complex. What if one process gets greedy and consumes the memory 'pooled' between several processes? What if the other processes don't want to give up memory? You'll easily end up with a race condition, bringing everything to a halt.

  • Thanks for your answer. The SQL Server's memory will be strictly regulated by max and min's server memory settings. – Patator Feb 11 '14 at 18:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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