EMC MULTISITE DISASTER RECOVERY FOR MICROSOFT SQL SERVER 2012 - White Paper & video's

EMC MULTISITE DISASTER RECOVERY FOR MICROSOFT SQL SERVER 2012

EMC VNX5700, EMC FAST Cache, SQL Server AlwaysOn Availability Groups

  • Mission-critical high availability
  • Automated storage optimization

 

SQL Server 2012 AlwaysOn Availability Groups provides the flexibility to protect specific databases, individually or collectively, in either synchronous or asynchronous availability modes. These configurations allow SQL Server 2012 the ability to replicate data to a secondary replica over distance.

 

The solution clearly shows the ability of EMC FAST Cache to significantly boost performance of the VNX Series storage array. Testing shows how enabling FAST Cache on a heavily utilized storage pool not only alleviated pressure, but allowed the same storage pool to service over four times the I/O (from 11,500 IOPS to 50,000 IOPS), while returning incredibly low SQL Server datafile average latencies times of 3 ms and less for reads and writes. The ability of FAST Cache to automatically react to the changes in OLTP workload I/O patterns is an invaluable tool for administrators.

 

While the performance improvements observed with these scenarios may not be representative of all Microsoft SQL Server 2012 environments, it nevertheless illustrates the potential to service far greater IOPS and reduce latency, using automated processes.

 

FAST Cache can also provide significant TCO savings by requiring far less drives than would be needed if FAST Cache was not enabled on the array. For example, by reducing power consumption and foot print, while at the same time simplifying the design and configuration for administrators required to optimize busy SQL Server 2012 environments.

 

The main findings of this solution are:

  • SQL Server AlwaysOn Availability Group technology brings significant improvements to the levels of native protection in terms of ease of use, monitoring, and performance compared to legacy native SQL Server protection offerings in previous versions.
  • EMC’s storage array platforms, such as the EMC VNX, have been fully validated by EMC to support critical, enterprise-level, SQL Server 2012 deployments in a multi-subnet disaster recovery configuration.
  • The VNX5700 can easily service 50,000+ SQL Server OLTP-like IOPS while providing high availability through the SQL Server 2012 AlwaysOn Availability Groups configuration.
  • Highlight the simplicity of enabling EMC FAST Cache technology to receive significant boosts in SQL Server 2012 transactional performance

 

Note    The EMC VNX5700 array can handle far more IOPS than recorded in this white paper. The performance achieved in this solution was with the given amount of storage devices (refer to the Solution configuration section), far higher levels of performance can be achieved in larger configurations.

 

Results clearly show the benefits of using EMC Technology with SQL Server 2012


 

 

...download the attached pdf to read the full EMC White Paper

 

Information

Link

Whitepaper Location

http://www.emc.com/collateral/hardware/white-papers/h10546-sql-server-2012-multisite-dr.pdf

 

https://community.emc.com/docs/DOC-14614 available as attachment

Technical Presentation

http://powerlink.emc.com/km/live1/en_US/Offering_Technical/Presentation/multisiteDR_SQLServer2012.pptx

 

Powerlink: Home > Solutions > Application Solutions > Microsoft > SQL Server > Virtual Infrastructure > Technical Validation

Camtasia Videos

 

EMC Solutions for SQL Server 2012

http://www.youtube.com/emcprovensolutions#p/c/FD6A4882DFEA91A2/2/D2Wprq-rTZo

SQL Server 2012 AlwaysOn

http://www.youtube.com/emcprovensolutions#p/c/FD6A4882DFEA91A2/0/hc0YKu1bJGs

EMC FAST Cache with SQL Server 2012

http://www.youtube.com/emcprovensolutions#p/c/FD6A4882DFEA91A2/1/ghsWGxLVxZE

EMC Storage Integrator

http://www.youtube.com/emcprovensolutions#p/c/FD6A4882DFEA91A2/3/pOsu3EK7qQw

EMC Unisphere Demo

http://www.youtube.com/emcprovensolutions#p/c/FD6A4882DFEA91A2/4/AUr54HdyR2E

Tech Articles:

Everything Microsoft @ EMC

EMC MULTISITE DISASTER RECOVERY FOR MICROSOFT SQL SERVER 2012

https://community.emc.com/docs/DOC-14614

EMC FAST Cache with SQL Server 2012

https://community.emc.com/docs/DOC-14618

Server 2012 AlwaysOn - high availability solutions overview

https://community.emc.com/docs/DOC-14614

SQL Server 2012 Availability Groups - Monitoring Performance (Dashboard, Performance Counters, T-SQL and PowerShell)

https://community.emc.com/docs/DOC-16251