Home / server / Questions / 230862
Accepted
Dan
Asked: 2011-02-04 13:43:22 +0800 CST

SQL Server 2008 R2 memory limit per instance or server?

  • 772

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?

licensing sql-server-2008-r2

2 Answers

  1. Best Answer

    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.

    • 1

  2. I believe those named-instances installed under Standard Edition will all utilize the same 64 gb of memory on your server.

    • 0