Solved

Hosting a critical application in MS Windows

Posted on 2011-09-22
10
281 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 121

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 143 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 286 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 NetCrunch network monitor licenses!

Only on Experts-Exchange: Sign-up for a free-trial and we'll send you your permanent license!

Here is what you get: 30 Nodes | Unlimited Sensors | No Time Restrictions | Absolutely FREE!

Act now. This offer ends July 14, 2017.

 
LVL 40

Assisted Solution

by:coolsport00
coolsport00 earned 286 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 286 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 121

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE^2)
Andrew Hancock (VMware vExpert / EE MVE^2) earned 143 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 286 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 71 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

Flexible connectivity for any environment

The KE6900 series can extend and deploy computers with high definition displays across multiple stations in a variety of applications that suit any environment. Expand computer use to stations across multiple rooms with dynamic access.

Question has a verified solution.

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

When converting a physical machine to a virtual machine using VMware vCenter Converter Standalone or vCenter Converter Enterprise, if an adapter type is not selected during the initial customization the resulting virtual machine may contain an IDE d…
When speed and performance are vital to revenue, companies must have complete confidence in their cloud environment.
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

717 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