March 25, 2014 at 5:44 am
Hi all,
In one of our production 64bit server having RAM 64 GB and two instancesof sqlservers(1default +1 named) running
How much i have to assign RAM for each instance.
Thanks in advance
March 25, 2014 at 6:07 am
Hi There,
This is a big question really. It depends will be the answer.. 🙂 you will need to look at things like what load is on each instance, what other software is on the server etc..
If you have nothing in place, a general place to start would be to allow 4GB for the OS then split the remaining 60GB over the two instances. Glenn Berry wrote about it here:
He also has some diagnostic tools which will help with working out better settings.
March 25, 2014 at 6:18 am
fyi... no need to configure 3GB switch as server is 64bit.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply