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?
RDFozz
11.7k4 gold badges25 silver badges38 bronze badges
1 Answer 1
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 Engine only other components like SSIS,SSAS,SSRS does not falls under this restriction and yes they can also consume good amount of memory.
answered Apr 21, 2017 at 6:30
-
Any impact on internal memory pressure because some time PLE drops down very low.user123253– user1232532017年04月25日 22:39:23 +00:00Commented Apr 25, 2017 at 22:39
-
PLE can drop down for many reason which necessarily does not means you have memory pressure. May be you are running massive index rebuild and other such queries are running requesting massive I/O in these cases PLE can fluctuate because buffer pool churns out more pagesShanky– Shanky2017年04月26日 05:23:11 +00:00Commented Apr 26, 2017 at 5:23
-
No jobs schedule to run during day time also IO is not very high during PLE Dropsuser123253– user1232532017年04月28日 23:43:57 +00:00Commented Apr 28, 2017 at 23:43
Explore related questions
See similar questions with these tags.
lang-sql
sql-servertag as the question has nothing to do with ssms. You can use ssms to set max memory.