emc multisite disaster recovery for microsoft sql server 2012 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
EMC MULTISITE DISASTER RECOVERY FOR MICROSOFT SQL SERVER 2012 PowerPoint Presentation
Download Presentation
EMC MULTISITE DISASTER RECOVERY FOR MICROSOFT SQL SERVER 2012

Loading in 2 Seconds...

play fullscreen
1 / 32

EMC MULTISITE DISASTER RECOVERY FOR MICROSOFT SQL SERVER 2012 - PowerPoint PPT Presentation


  • 135 Views
  • Uploaded on

EMC MULTISITE DISASTER RECOVERY FOR MICROSOFT SQL SERVER 2012. EMC VNX5700, EMC FAST Cache, SQL Server AlwaysOn Availability Groups. Strategic Solutions Engineering (SSE) EMC Solutions Group (ESG) David Ring Michael Morris. Agenda. EMC Proven Solutions SQL Server 2012 Overview

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'EMC MULTISITE DISASTER RECOVERY FOR MICROSOFT SQL SERVER 2012' - dallon


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
emc multisite disaster recovery for microsoft sql server 2012

EMC MULTISITE DISASTER RECOVERY FOR MICROSOFT SQL SERVER 2012

EMC VNX5700, EMC FAST Cache,

SQL Server AlwaysOn Availability Groups

Strategic Solutions Engineering (SSE)

EMC Solutions Group (ESG)

David Ring

Michael Morris

agenda
Agenda
  • EMC Proven Solutions
  • SQL Server 2012 Overview
  • Solution Overview
  • Architecture Design
  • Test Results
  • Summary
  • Q&A
emc proven solutions approach

Cork, Ireland

Shanghai, China

Hopkinton, MA

Singapore

Santa Clara, CA

Vienna, Austria

EMC Proven Solutions Approach

1

2

3

4

Capture and define

Test and validate

Document

Publish

Requirements

…we champion the customers

…and test the solutions you would like

alwayson failover cluster
AlwaysOn Failover Cluster
  • Shared storage
  • Passive secondary replicas
  • Protects server, instance, and database
  • Multi-subnet support now available
  • Database Protection
  • Microsoft SQL Server AlwaysOnFailover Cluster
sql server 2012 multi subnet support
SQL Server 2012:Multi-subnet Support
  • Cluster Setup support—intelligently detects a multi-subnet environment
  • SQL Server Engine support—skips binding to any IP address that is not in an online state
  • Cluster Properties—Dependencies
alwayson availability group s
AlwaysOn Availability Groups
  • Synchronous or Asynchronous
  • Up to four replicas
  • Active secondary replicas
  • Protects database only
  • Database Protection
  • Microsoft SQL Server AlwaysOn Availability Group
solution purpose
Solution Purpose
  • SQL Server 2012 AlwaysOn
    • Characterize a geographically dispersed SQL Server 2012 environment protected by AlwaysOn technology, and highlight multi-subnet support at both synchronous and asynchronous distances.
  • EMC VNX5700
    • Optimize database storage performance with EMC FAST Cache.
    • Integrate a simple, efficient, and powerful platform for enterprise-class SQL Server 2012 infrastructures.
    • Validate the ability of the VNX5700 storage array to support SQL Server 2012 instances running OLTP-like workloads that generate over 50,000 IOPS.
slide13

Solution Architecture

2 * SQL Servers

  • 1 * Primary (Production)
  • 1 * Secondary (DR)

FAST Cache on production

  • 4 * DB’s: 1.8 TB of data
  • Dataset: 60% hot

FAST Cache impact:

x4 (TPS/IOPS)

latency of <3ms

storage design
Storage Design

Production array storage configuration

slide19

Throughput in IOPS (transfers/sec)

  • Baseline
  • 2hr FAST Cache warmup
  • FAST Cache Steady State

Distance ...80km

...800km

…4,000km

Transfers/sec (IOPs)

slide21

SQL Server CPU Utilization

  • SQL Server CPU impact across synchronization state and distance
slide22

Throughput in Transactions/Sec (TPS)

  • Baseline
  • 2hr FAST Cache warmup
  • FAST Cache Steady State

Distance ...80km

...800km

...4,000km

  • Disk transactions per sec (TPS) for both primary and secondary replicas
slide23

Physical Disk Utilization

  • Baseline
  • 2hr FAST Cache warmup
  • FAST Cache Steady State

Physical disk utilization for storage pool on production and DR arrays

slide24

Storage Processor Utilization

  • Baseline
  • 2hr FAST Cache warmup
  • FAST Cache Steady State
  • SP utilization for SPA and SPB on production and DR storage arrays
shared storage r equirements f or s eeding
Shared Storage Requirements For Seeding
  • A shared storage space is required when performing a Full Initial Data Synchronization as part of availability group creation.
  • Users should consider the storage used for these database backups and restorations.
  • The backup process has high bandwidth requirements for storage.
availability group creation times
Availability Group Creation Times
  • Synchronous and asynchronous availability group creation at 80, 800, 4,000 km
slide29

Summary

AlwaysOnAvailability Groups provide protection at database level

  • Synchronous – commit mode
  • Asynchronous – commit mode
  • Powerof the EMC VNX to host mission critical SQL Server 2012 environments

FAST Cache

  • significantly boost performance
  • Incredibly low SQL Server datafile latency <3 ms

FAST Cache increased SQL Server throughput by x4 (TPS/IOPS) while maintaining a very low latency of <3ms