1 / 32

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. EMC Proven Solutions SQL Server 2012 Overview

dallon
Download Presentation

EMC MULTISITE DISASTER RECOVERY FOR MICROSOFT SQL SERVER 2012

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 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

  2. Agenda • EMC Proven Solutions • SQL Server 2012 Overview • Solution Overview • Architecture Design • Test Results • Summary • Q&A

  3. 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

  4. SQL Server 2012 OverviewHigh Availability

  5. SQL Server 2012 New Feature Overview

  6. SQL Server AlwaysOn

  7. SQL Server High Availability Features

  8. 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

  9. 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

  10. AlwaysOn Availability Groups • Synchronous or Asynchronous • Up to four replicas • Active secondary replicas • Protects database only • Database Protection • Microsoft SQL Server AlwaysOn Availability Group

  11. Solution Overview

  12. 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.

  13. 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

  14. Architecture Design

  15. SQL Server Layout

  16. Storage Design Production array storage configuration

  17. Storage Design for SQL Server

  18. Test Results

  19. Throughput in IOPS (transfers/sec) • Baseline • 2hr FAST Cache warmup • FAST Cache Steady State Distance ...80km ...800km …4,000km Transfers/sec (IOPs)

  20. Comparison of Disk Reads/Writes On Primary And Secondary Replicas

  21. SQL Server CPU Utilization • SQL Server CPU impact across synchronization state and distance

  22. 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

  23. Physical Disk Utilization • Baseline • 2hr FAST Cache warmup • FAST Cache Steady State Physical disk utilization for storage pool on production and DR arrays

  24. Storage Processor Utilization • Baseline • 2hr FAST Cache warmup • FAST Cache Steady State • SP utilization for SPA and SPB on production and DR storage arrays

  25. Availability Group Creation Process

  26. 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.

  27. Availability Group Creation Times • Synchronous and asynchronous availability group creation at 80, 800, 4,000 km

  28. Summary

  29. 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

  30. Q&A?

  31. THANK YOU

More Related