If SQL Server 2008 R2 standard edition is limited to 64 GB of memory, then is it required to restrict the max memory for multiple instances (3) which are running SQL server 2008 R2 standard edition with 256 GB of RAM installed on windows server 2012?
Sql-server – Memory utilization for multiple instance (SQL server 2008R2 standard edition)
sql serversql-server-2008-r2ssmswindows-server
Related Question
- SQL Server – Maximum and Minimum Memory Configuration
- Why Isn’t SQL Server Using the Max Server Memory Setting?
- Sql-server – SQL Server 2012 Standard using too much memory
- Sql-server – SQL Server 2008 R2 Standard Edition not using more than 32GB for BufferPool
- Sql-server – System Memory (RAM) for Windows Server 2012 Standard with SQL Server 2012
- Sql-server – Why SQL Server Standard 2017 is using more memory than limit described in documentation
Best Answer
You can leave it to default for all instances because since it is SQL Server 2008 R2 standard edition it will not use more than 64 GB and you ahve total of 256 GB RAM so you are on safer side. Please also note that 64GB limitation is for
Database Engineonly other components like SSIS,SSAS,SSRS does not falls under this restriction and yes they can also consume good amount of memory.