?
Solved

Hosting a critical application in MS Windows

Posted on 2011-09-22
10
Medium Priority
?
282 Views
Last Modified: 2012-05-12
What software should I be using if I am trying to make sure a MS SQL application has high availability.  Is ESXi a suitable candidate to do that?  Would you elaborate the process to provide high availability for hosting a critical application?
0
Comment
Question by:tommym121
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
  • +2
10 Comments
 
LVL 122

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 572 total points
ID: 36580809
But you could also use Microsoft Clustering:-

How much downtime can you afford?

Possibly, VMware Technology may give your High Availability with the following:-

VMware vSphere Availability Features

VMware High Availability - Decrease Downtime and Reduce Risk
http://www.vmware.com/products/high-availability/overview.html

VMware High Availability (HA) Product Briefs
http://www.vmware.com/pdf/ha_datasheet.pdf
http://www.vmware.com/files/pdf/VMware-High-Availability-DS-EN.pdf

VMware Fault Tolerance - Deliver 24 X 7 Availability
http://www.vmware.com/products/fault-tolerance/overview.html

VMware Fault Tolerance Product Brief
http://www.vmware.com/files/pdf/VMware-Fault-Tolerance-FT-DS-EN.pdf

VMware vSphere Availability Guide ESX 4.1vSphere
http://www.vmware.com/pdf/vsphere4/r41/vsp_41_availability.pdf

0
 
LVL 40

Assisted Solution

by:coolsport00
coolsport00 earned 1144 total points
ID: 36580863
What you need is a combination of things. VMware has "high availability", but that doesn't mean 'continuously' running. There is a brief downtime in the event a host the MS SQL VM is on goes down. What you need, in conjunction with VMware HA is FT, and/or Microsoft Clustering, both of which are compatible on VMware vSphere. @hanccocka has provided links that further explain the technologies. You will first need to determine SLAs and potential downtime you can have, then go with the solution that 1. fits in with your requirements, and 2. that fits into your budget.

Regards,
~coolsport00
0
 

Author Comment

by:tommym121
ID: 36580865
It is a CRM system that is strategic to the entire company operations. we would like to have it on 24 hours.  It can be down for 30 min to an hour max. Ideally no downtime.

Even when we expand our operations and need hardware upgrade, we like to be able switch over to new hardware without any downtime if possible.
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
LVL 40

Assisted Solution

by:coolsport00
coolsport00 earned 1144 total points
ID: 36580882
Well, you can use HA & FT. If you decide to implement MSCS, here is the VMware guide for that:
http://www.vmware.com/pdf/vsphere4/r41/vsp_41_mscs.pdf
0
 
LVL 10

Expert Comment

by:ImaCircularSaw
ID: 36580888
SQL Mirror on a seperate site with a witness server locally that can manage the quorum(sp?) and fail-over automatically.
0
 
LVL 40

Assisted Solution

by:coolsport00
coolsport00 earned 1144 total points
ID: 36580891
Since you actually can have "some" downtime, costs may determine what amt of downtime you can have. HA alone doesn't cover you in the event of a lost VM server. That is only for a ESX/i host failure. And the VM that is on the failed host will then be restarted on remaining working hosts in the HA Cluster. So, what you need is FT and/or MSCS as well.
0
 
LVL 122

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE^2)
Andrew Hancock (VMware vExpert / EE MVE^2) earned 572 total points
ID: 36580957
VMware vSphere HA will do what you need to do.

But note, if a host server fails, you will experience a downtime of between 1-2mins whilst the server is restarted.

If you require better availability you will need to use FT, but, remember with FT, if the OS fails because of a fault, the FT VM will also fail.
0
 
LVL 40

Assisted Solution

by:coolsport00
coolsport00 earned 1144 total points
ID: 36580975
HA will provide 'uptime RTO', but doesn't provide recoverability in the event of a corrupted VM. FT and/or MSCS helps with that since there is more than 1 VM (server) clustered for high availability. Another option is to only use HA, and have a current backup of the VM using Veeam Backup & Replication, vRanger, or other 3rd party VM backup tool.

~coolsport00
0
 
LVL 5

Assisted Solution

by:Sebastian Talmon
Sebastian Talmon earned 284 total points
ID: 36582940

you could use mirroring/replication at the database-level - for an SQL Server, this is a very common scenario

maybe this document is a nice overview:
http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/replicationanddbm.docx
"SQL Server Replication: Providing High Availability using Database Mirroring"


As the replication takes place at the database level, an error in your Windows-Installation only affects the faulty machine and not the replication partner (or the SQL data)


(but using the HA or FT features in VMware is also a good idea - but I would prefer using the database-based replication / maybe together with VMware HA or FT)
0
 

Author Closing Comment

by:tommym121
ID: 36599290
Thanks for all the help. Very informative.  I will post more specific questions for your further assistance. Thank.s
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When rebooting a vCenters 6.0 and try to connect using vSphere Client we get this issue "Invalid URL: The hostname could not parsed." When we get this error we need to do some changes in the vCenter advanced settings to fix the issue.
For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question