Venkateshwari Murari

Protecting Microsoft® SQL Server® 2014 with Hitachi Data Instance Director in a Two Site Environment

Blog Post created by Venkateshwari Murari Employee on Oct 5, 2016

Business Problem Statement

SQL Databases form the backbone of many critical applications. Traditionally their data is protected using VSS and Microsoft DPM or Symantec Netbackup which stream data and logs to a backup target, such as tape. With the growth in data, this model is becoming strained. The amount of time needed to complete backups and recoveries are not meeting business requirements. Many organizations either fail to meet business level Service agreements or overspend for higher level of data protection than necessary for individual data sets. Most organizations address this issue by traditional approach of deploying a number of point solutions. This has given rise to an increased complexity, cost and risk as it becomes difficult to manage these solution silos.

To address these problems, customers are increasingly turning to hardware-based snapshots and replication but this is not easy. Generally, in-depth knowledge is needed to create scripts to manage this hardware based data protection. Changes to the environment such as the addition of capacity need careful management and constant updating of scripts. Customers rely on staff with this deep technical knowledge during setup, maintenance and restoration of data. There is risk in having human generated scripts and there is risk in reliance on a handful of staff with this specialized knowledge.

 

Business benefit and Solution Value Propositions

HDS approach to this problem is to provide all of the data protection technologies  under single integrated easy to use platform with a unique business defined workflow and policy engine to orchestrate the data management operations through Hitachi Data Instance Director (HDID). HDID has a seamless end-to-end optimized Solution for Backup, Replication, and Recovery for SQL Server and Data Protection.

Protecting SQL 2014 with HDID in a two site environment is based on proven Microsoft SQL Server database to propose Disaster Recovery (DR) for on-premises systems.

This pretested, backup, replication solution and recovery can be used to accelerate data protection with reliability, redundancy, scalability, high availability while processing small-scale to large-scale OLTP workloads and management with HDID centralized console.

 

Overview

This blog provides a high level view of the tested architecture and test results on protecting such SQL Server environment in a single site and also using clone features for SQL Server Database using HDID.

High-level concepts covered in the white paper:

  • Concurrent snapshot (Hitachi Thin Image (HTI) – Hitachi TrueCopy – Hitachi Thin Image)
  • Concurrent snapshot (Hitachi Thin Image – Hitachi Universal Replicator (HUR) – Hitachi Thin Image)
  • Clone with Hitachi ShadowImage Replication

Storage Architecture

This section describes the storage architecture used for the testing documented in the white paper. It takes into consideration Hitachi Data Systems and Microsoft recommended practices for the deployment of database storage design.

 

Test Results

 

These are the test results of protecting SQL 2014 with Hitachi Data Instance Director in a two site environment.

 

Test execution results Metric

Value

Site 1 Database Configuration

SQL Data base size

1 TB

Total number of data files

12 TB

Database fill factor

90%

Concurrent Snapshot (HTI – TrueCopy – HTI)

TrueCopy Replication time

2 Hours 06 Minutes

Site 1 Hitachi Thin Image Snapshot time

1 Minutes 24 Seconds

Site 2 Hitachi Thin Image Snapshot time

1 Minutes 13 Seconds

TrueCopy Replication Mount time

4 Minutes 11 Seconds

Manual Complete recovery time

Approximately 4 Minutes

Concurrent Snapshot (HTI – HUR – HTI)

Hitachi Universal Replicator time

3 Hours 30 Minutes

Site 1 Hitachi Thin Image Snapshot time

1 Minutes 33 Seconds

Site 2 Hitachi Thin Image Snapshot time

1 Minutes 21 Seconds

Universal Replicator Mount time

6 Minutes 09 Seconds

Manual Complete recovery time

Approximately 5 Minutes

 

Outcomes