Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

VMware or Microsoft Cluster Solution Expand / Collapse
Author
Message
Posted Tuesday, August 21, 2012 5:12 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 2:56 PM
Points: 384, Visits: 1,260
Very simple question.

I used to work for a big, big company. But changed job recently and on my new role, I was asked to provide advice on our soon to be deployed, SQL server infrastructure. I never worried about picking the servers before, the IT dpt dit, but I know by facts VMware was giving us some performance issues and we trusted our million dollars dbs to Veritas and Microsoft SQL clustering instead. It work really good and still I believe it does.

Back to my new job and role, the consultant company pretty much says VMware HA features are far better than an actual MS-SQL cluster (2 nodes, active passive) which I strongly disagree. So, I thought having an "impartial" feedback here may confirm or deny some of my statements, based on other experiences, of course, not books or theory.

I do not want to start a heated debate about the topic, but get some opinions, hopefully from people that have had some real exposure to both products.

--What my bosses want --

HA for our MS-SQL databases

--What the proposal is ---

Deploy VMware and move all databases there.

--What I am suggesting ---

A hybrid model. One or two MS-SQL instances running on VMs; deploy 80% of our databases there. Plus a real Microsoft two node cluster, with only 2 or 4 mission critical databases on it, including our most important database, which is over of 1TB of size.

Comments and opinions are welcome.

Thanks in advance,
Post #1348136
Posted Thursday, August 23, 2012 2:55 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 11:00 AM
Points: 979, Visits: 5,090
My stand on it would be, who's going to be supporting the configuration?
If it's you, and you aren't familiar with / comfortable with setting up VMWare and managing it (I'd presume the consultants would be doing the initial setup but will the bosses keep paying their fees?) then go with the SQL cluster.

Really, to some extent, it's nothing more than one cluster solution over another. Either way, a catastrophic server failure will still result in some downtime, either while SQL switches hosts, or while the VMWare switches hosts.

Jason
Post #1349361
Posted Tuesday, August 28, 2012 4:04 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:09 AM
Points: 6,288, Visits: 13,547
Virtualisation is performed for consolidation purposes not performance, not every sql server is a suitable virtualisation candidate, this must be remembered when deciding what to virtualise

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1351314
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse