Ask your questions for Eli and the rest of the Silicon Discourse community here. Build your reputation by giving advice to others too!
I have a client that has:
- a web server which hosts their asp.net web application
- a separate windows server just for AD authenticaion (to allow users to login to their site)
- and a separate MS SQL Server
They want to save money by virtualizing some of these (using VMware).
I’m worried the SQL server will take too much of a performance hit by being virtualized, even if it is linked to the virtualized web server by high speed internet.
Has anyone successfully virtualized a SQL server with medium traffic before?
Here’s what you need to do, you could take the domain controller and test out Hyper-V to try and virtualize the SQL server off of it and for the web server, see if you can move that into the cloud either hosted on Azure or AWS’s platform.
So, basically then you’ll have one physical server which doubles as your domain controller and hypervisor for the virtualized SQL server along with your cloud server for the hosted .NET application.
You’ll have to do some research on different backup solutions for that piece of hardware, probably a SAN would work.
You can virtualize pretty much any server. I believe you are asking the wrong question though, what do you mean by “safe”? Honestly, you could likely put all of those in the same box, but if you are asking this question, I would find someone more experienced to do it for you, as setting up utilization can be a little tricky for SQL servers if you have never done it before. The biggest hit it could potentially take, is from setting it up wrong.
I actually visited one of my schools data centers last week.They were talking about how over the last five to ten years they reduced this room full of racks which were all completely populated to racks which were only ten percent occupied mostly thanks to virtualization. This had several benefits mostly with cost savings from lower power consumption and less maintenance as a result of having fewer physical machines.
And yes, this infrastructure supports something along the lines of 60,000 users, machines, digital signage and even many database queries.
This kind of amazes me in a sort of way. Ten something years or so I thought something along the lines of virtualization being something of a tech nerds toy rather than something to use in production but now it seems like there is a logical trend toward virtualization first rather than a second place technology.