Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


VMware or Microsoft Cluster Solution


VMware or Microsoft Cluster Solution

Author
Message
sql-lover
sql-lover
SSChasing Mays
SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)SSChasing Mays (651 reputation)

Group: General Forum Members
Points: 651 Visits: 1930
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,
jasona.work
jasona.work
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1853 Visits: 10886
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
Perry Whittle
Perry Whittle
SSCrazy Eights
SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)SSCrazy Eights (8.8K reputation)

Group: General Forum Members
Points: 8772 Visits: 16543
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" ;-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search