asked
Allocating the RAM for two SQL SERVER instances availbale in the same box ?
Customer have two instances on one box and sever having 38GB RAM. He asking us to allocate 16GB for one SQL instance and 20 GB for another SQL instance how will you allocate? any one help us, thanks in advance Chalapathi P
Requesting moderators/Questioner to shift this question to the Default instance please.
You need to set MAX MEMORY setting on both of these instances, one to 16GB and the other one to 20GB. Also make sure you set the MIN MEMORY setting as well when running multiple instances to make sure, in the event of a memory pressure, the instances won't starve of needed memory.
Personally, I would advise that @Chalapathi restricts the memory a little further, allowing Windows more than just 2GB. There's all sorts of guidance out there, though!
I agree. I'd read Jon's blog post --
https://www.sqlskills.com/blogs/jonathan/how-much-memory-does-my-sql-server-actually-need/ -- even thought in SQL Server 2012 the memory manager has been re-designed, you could use apply the logic.
18 People are following this question.
