August 22, 2013 at 12:18 pm
Hey folks.. here part of the situation. We're going to P2V some sql servers. I'd like to find the average cpu core usage and the minimum memory requirements for server/database so I know what each VM will require at a bare minimum to continue efficient operations. I realize that with our current configurations SQL Server sucks up the memory allocated to it but if I've allocated 8 gigs and it grabs all that memory, how much of it does it really use on a consistent basis? Does it need 8 gigs? Can it make do with 1? 2? Does it require more than two cores? Does it even need more than one core if it's a low usage system?
Anyone have any scripts that can give me this kind of information?
Thanks,
Erin
August 22, 2013 at 12:29 pm
I think cores can be hard because memory can affect CPU.
I'd suggest looking at Target Server memory for the current instances. I'd also talk to the VM Admins and make sure you don't pack the VMs as tightly as you might for non-db servers. Print servers don't have the requirements of database servers.
I had some friends that (in general) did 10:1 for VMs to hosts. For SQL Servers, it was 4:1.
August 22, 2013 at 12:52 pm
Thanks, Steve. I can wish for a magic bullet but I think I'll be rolling up my sleeves for this project.
4:1? Do you know if those were high volume OLTP instances? Most of these are fairly low volume instances that aren't pushing much data. I was thinking, personally, something along the lines of 30:1 on a large server cluster with 10 gig datalines.
August 22, 2013 at 1:51 pm
They weren't and this was the guideline in the previous versions of VMWare.
They might be higher now. I'd have to check.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply