SQL Server 2008 R2 memory limit per instance or server?
I'm getting ready to deploy a new SQL server and realized that the memory limit of SQL Server 2008 R2 is supposedly 64GB of RAM (http://www.microsoft.com/sqlserver/en/us/product-info/compare.aspx). Potentially an upside, there will be many instances of SQL server on this box. Does anybody know if the 64GB limitation is per server or per instance?
Solution 1:
I'm reasonably confident that it's per-instance. If you want a simple way to test just to see for sure, fire up a few instances of Express, which is limited to 1 GB.