Link to home
Start Free TrialLog in
Avatar of Wayne Barron
Wayne BarronFlag for United States of America

asked on

2016 server Core. Memory for IIS and SQL server 2019 (separate vms)

Hello all.

Working with windows 2016 Core servers VMs.

To run the following on separate servers of course.

IIS and SQL server 2019.

How much memory would be good for these vm cores?

I have 3 2016 file servers that run wonderfully with only 1gb of ram.

So how much for the others?
Waynr
ASKER CERTIFIED SOLUTION
Avatar of Philip Elder
Philip Elder
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Wayne Barron

ASKER

I have 3 SQL servers running now at 6gb each memory. These are desktop experience installation.
The IIS servers are running 6gb as well and they are also desktop experience.

I want to go all Core servers.
I read a while back that with core I would not need but about 1/2 the memory of what desktop uses.


the memory footprint saving stated is just for the core OS .. i.e. new installation of Server 2016/19 IIS and SQL Server add onto that base memory .. They both work better with more memory the better though depending upon your workloads you will reach a point of diminishing returns.
Biggest hint is don't let SQL use its default maximum memory of 104PB of ram .. set its maximum to your total configured memory - 2MB use ssms servername properties memory to change this. 
What I am thinking of is resources on the server.
If I use Desktop experience 2016, then the resources used on the desktop takes away from either IIS or SQL Server.
So, installing Core will eliminate the additional resources used up for the desktop experience.
I successfully have a Core IIS running, as of last night (Talk about being happy and proud when it started serving up sites in the IIS Farm. Love it)
I have 48GB of ram on this server right now, plus 32GB of ram to add to replace the 4x4gb sticks with 4x8gb to make it 64GB of ram to utilize. (This I will swap over this weekend)
And with the File Servers working excellent with 1GB of ram each (They are just used to upload images and media too, and they are used by the IIS servers to grab the images and media from to show on the website(s))
I am going to create two more of them over the weekend, to make it 5 x 1GB Core File Servers.
So that is only 5GB of ram, -4gb for VMWare ESXi
That leaves me with 47GB of ram.
I have 6GB of each of the IIS and SQL Server Desktop Experiences right now.
So, that is why I opened this TA, is to find out if running Core, if I could go with maybe
4GB for IIS and SQL Server each?
Right now, I do not have a significant load on the servers, maybe 1,000 hits a day on all sites. (During peak, when my main two sites get hits from YouTube follow through links, it can reach several thousand hits a day just on the two sites alone, not including the other five sites)
Now, the music site I am working on, might change for views per day on it, so I will just have to monitor it when that time comes, and maybe bring in one of the other servers, and dedicate it to the music site on its own, and allocate all the memory from that server to maybe 5 VMs. But that is thinking of the future.
Right now, I am wondering about the now.

If SQL is running with 6GB of RAM then that's what it would need when running on top of Server Core. Keep in mind that SQL 2019 is memory tuned meaning that the more memory you throw at it the better it performs.
ok
Seriously, Andy?
You post about the memory size, not knowing the system that it is in?
When the question has to do with software and memory?
Why?

And for your information, it is an older Intel Server.
8x8gb sticks will top out this particular server.
So, 16gb in 2020, has absolutely Nothing to do with anything, in this case.
Update.

I have all my IIS Servers running on CORE now.
Everything is running well at 4GB per server and there is 5.
I am going to work on the CORE for SQL Server next.
And that I will take on later on today.

What I do is create a server core, install all needed software, then a copy it into a new server folder for the amount of VM's that I will need, and then I will create the VM's and point the Hard Drive to the existing drive.
It works like a charm.
here is my read of the situation.
1) the benefit of using core is reducing the waste of resources in the VM for the GUI.
2) as you noted in your scolding of andy's comment though can not see it. You know what you are asking, but have not provided the info you know is needed.

The more memory as noted the better the performance of SQL which is a memory hog.

How large are your DBs and what is their projected data growth rates.
Number of users hitting the .....
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial

Thanks, everyone, for the great information.

Server core, to be honest; when I first saw a video on it, I was not too keen on messing with it.

But the more I looked into the technology and what it could offer in resource management and keeping the resources down to be utilized for other services that need them. I became more in tune with it, so I jumped in.


The first server core I built was a file server, which is still used today.

I got it perfect and the way I needed it to work. So I threw 1gb of ram at it and discovered that was all it needed.

I mean, what else do you need when the only thing the server is doing is answering the request for files?

However, if I notice a significant hit on the file servers, I will add more ram to them, but for now, it is at 1 GB.

I created copies of it and placed them in four other VM folders and have not looked back since.


After some Drive failures over the weekend (2 drives, one went last night, and the other went this morning sometime. Damn, how I love Raid 5. I Had that one drive for redundancy and saved my data big time)

Ordering a bunch of new disks that should be in by the end of the week)


The IIS Core Servers are currently running well with 2GB of ram.

There does not seem to be any issues. But, then again, they're not under a heavy load at the moment.


I have a few DELL r710 Servers that I will be bringing online by the summer, and at that time, I will be able to add more ram to my VMs.

I am going to close this one out.

However, please continue to add to this, as I am sure others will enjoy reading, as I have, the great "What I Do" from everyone.


Thanks, Wayne