DxHADR for SQL Server

High Availability/Disaster Recovery Orchestration Platform for SQL Server

Download a PDF | Watch the Webinar

The SQL Server Availability Problem

Every business using Microsoft SQL Server to manage mission critical business processes should have both a high availability and a disaster recovery (HADR) plan that enables it to continue business operations in the event of a natural or man-made outage. A HADR plan is different from having a backup plan. Most businesses backup their data so they can restore their files in the event of a critical issue. However, data backup does not detect a fault quickly or restore critical business operations in near real-time after a primary database server has been lost.

That's what a HADR plan is for - to drive the time to restore service to your critical database instances to minutes instead of hours or days. You need a HADR implementation because the cost of downtime is too expensive to the business. According to an Aberdeen study done in 2012, mid-size/enterprise organizations experience 3.25 downtime events per year.1 That doesn't seem like often, but the cumulative yearly cost of these downtime events is quite large. For a mid-size company the yearly average downtime cost is $880K; for an enterprise company the average yearly downtime cost is $2.8M.

The underlying problem is that most SQL Server instances are not protected by high availability mechanisms and/or disaster recovery methods that deliver low Recovery Time Objectives (RTO) required by the business. Most SQL Server implementations don't have HADR capabilities because building them is often deemed too complex and/or too expensive.

Challenges for Reliable HADR Solutions for SQL Server

  • Budgetary constraints dictate that both High Availability & Disaster Recovery (HADR) for SQL Server instances must be delivered as one
  • Recovery Time Objectives (RTO) require fully automated fault detection and failover in order to meet SLA requirements
  • Customizable automation capabilities are not included in current HADR offerings
  • Offered solutions often lock customers to a particular infrastructure, hypervisor, or cloud provider, limiting agility
  • Due to complexity of current HADR offerings, stand-alone deployments have often demonstrated higher availability
  • There are, or may be, dependent application(s) and/or services that also must be coordinated to meet service delivery SLAs
    • Current options for SQL Server HADR only addresses the SQL Server instance or database availability with limited to no dependency coordination
  • There is no consistent method to address the above requirements across multiple different OS & SQL Server versions and/or editions


The Solution

Fortunately for SQL Server users, DxHADR delivers an integrated, high value, low cost, simple-to-manage solution for every version and edition of SQL Server. Now you can not only afford to protect all your SQL Server instances and maintain business continuity when the inevitable failure happens, but you also can do it simply and reliably.

DxHADR is a best in class solution for extending high availability disaster recovery services for Microsoft SQL Server from any source to any target. Within seconds of a failure, your SQL Server instances will automatically be made available at your alternate location while maintaining the exact same application connection string. Full multi-subnet aware clustering provides simple failover without the networking complexity - there is no requirement of spanning subnets across locations.

Based on DH2i's InstanceMobility technology, DxHADR software orchestrates and automates HADR, recovery, maintenance, and management of SQL Server instances across heterogeneous physical, virtual, or cloud infrastructure. In the event of an outage SQL Server instances are dynamically re-hosted from on-premises to your alternate site, to the cloud, or across heterogeneous clouds in seconds rather than hours or days. A single operational model and console ensures seamless coherent management of both your DR site and on-premises SQL Server instance workloads. Active policy-based monitoring intelligently automates IT operations to maintain required SLA and QoS contracts for all SQL Server instances, regardless of location.

How Does It Work?

DxHADR

DxHADR works with any third-party host, array, appliance or backup based replication technology that can replicate SQL Server data from any type of production server to any type of secondary server located anywhere in the world. By utilizing DH2i's InstanceMobility technology, which eliminates the need for Windows Server Failover Clustering (WSFC), DxHADR allows you to implement multi-site clusters into environments without shared storage or geographic limitations. This removes a critical single point of failure and makes it simple to deploy cluster nodes into the cloud or wherever you want. The result is a reliable and efficient HADR solution that enables the failover of SQL Server instances between heterogeneous on-premises and cloud infrastructures.

Summary of Benefits of DxHADR

DxConsole HADR edition automates and orchestrates high availability and disaster recovery operations for SQL Server. Benefits include:

For the Business

  • Extend automated high availability disaster recovery services to all versions and editions of SQL Server across any combination of underlying OS's
  • Recover SQL Server instances into the cloud or recover instances on-premises in seconds through InstanceMobility
  • Build a hybrid SQL Server HADR infrastructure optimized for price/performance
  • Guarantee instance-level SLA contracts for performance & availability by intelligently tying SQL Server instance QoS to business value with automatic load balancing
  • Manage all your on-premises and cloud-based SQL Server instances with a single operational model - for an optimized SQL Server management infrastructure
  • Streamline SQL Server patch management by "pushing" updates or hot fixes to all managed SQL Server instances, on-premises and in the cloud, from a single point of control
  • Reduce software and support costs by at least 50%
  • Save as much as 80% on total cost of ownership of SQL Server over a three-year period

For the Technical Team

  • Monitor SQL Server health and performance with customizable alerting
  • Ensure the availability of SQL Server instances through automated failover to a replicated disaster recovery site or cloud
  • Deliver coordinated control of dependent applications or services
  • A single consistent application connection string to SQL Server instances regardless of where they are running
  • Facilitate SQL Server instance failover across subnets
  • Create DRaaS for all SQL Server instances to any target anywhere
  • Simple to implement and manage, i.e. low complexity
  • Address overall service delivery for SQL Server and dependencies seamlessly
  • Make every instance highly available and resilient with a single HADR mechanism
1 Why Mid-Sized Enterprise Should Consider Using DR-as-a-Service, AberdeenGroup 2012

Download a PDF | Watch the Webinar