EMC Storage Optimization and High Availability for Microsoft SQL Server 2008 R2

The EMC Storage Optimization and High Availability for Microsoft SQL Server 2008 R2:  EMC VNX5700, EMC FAST Suite, and VMware vSphere 5 white paper has been published on EMC.com.

 

http://www.emc.com/collateral/hardware/white-papers/h8987-mssql-vnx5700-wp.pdf

 

This solution demonstrates the ability of the EMC VNX5700™ storage array to support over 50,000 input/output operations per second (IOPS) when running multiple OLTP-like workloads. The solution shows the benefits of introducing Flash drives to the environment and enabling EMC FAST VP and EMC FAST Cache to boost performance in an automated fashion.

The solution also compares and profiles restart times and considerations for local HA techniques in:

  • A Microsoft SQL Server clustered virtual environment
  • A standalone VMware HA environment

 

The main results of this solution were:

 

  • The VNX5700 can easily service 50,000+ Microsoft SQL Server online transaction processing (OLTP)-like IOPS. 
  • The combination of FAST VP and FAST Cache allows VNX series storage arrays to maximize storage efficiency and service increased I/O. This solution shows a three times improvement in ability to service I/O from a total baseline of 14,435 IOPS to an I/O peak of 51,471 with FAST Suite enabled.

 

 

Main Solution Video: http://youtu.be/j_GEsfTJpbE

 

Solution pack:

EMC Storage Optimization and High Availability for Microsoft SQL Server 2008 R2:

Enabled by EMC VNX5700, EMC FAST Suite, and VMware vSphere 5


 

Information

Link

Whitepaper:

EMC.com: http://www.emc.com/collateral/hardware/white-papers/h8987-mssql-vnx5700-wp.pdf

 

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

 

 

Technical Presentation:

EMC.com: http://uk.emc.com/solutions/application-environment/microsoft/solutions-for-sql-server-business-intelligence.htm

 

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


ECN Articles:

Link

EMC Storage Optimization and High Availability for Microsoft SQL Server 2008 R2:  EMC VNX5700, EMC FAST Suite, and VMware vSphere 5

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

EMC Storage Optimization and High Availability for Microsoft SQL Server 2008 R2

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

Back-end SAS port balancing

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

VNX - Workload balancing

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

VNX - Sizing FAST VP pools and FAST Cache

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

Using EMC VSI 5 VMware vCenter Plug-In - with video demo

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

Using vSphere hot add to dynamically add CPU - with video demo

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

Multi-NIC vMotion in vSphere 5 with SQL Server - with demo video

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

vSphere 5 Virtual Machine Failure Monitoring

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

VMware vSphere 5 PVSCSI and LSI Logic SAS adapters

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

vSphere 5 Storage DRS IO Load Balancing - with demo video

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

vSphere 5 Storage DRS based on Datastore Capacity Utilization - with demo video

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

 

 

EMCProvenSolution YouTube Channel

Link

EMC VNX Fast Suite and Microsoft SQL Server 2008 R2

http://youtu.be/j_GEsfTJpbE

VMware vSphere 5 - Using Image Builder To Create Custom ISO

http://youtu.be/AfjEyB2FTwc

Using EMC VSI 5 VMware vCenter Plug-In

http://youtu.be/6lRq9ha7_5w

Using VMware vSphere 5 Hot-Add to Dynamically Add CPU

http://youtu.be/GnvXt6bug00

Multi-NIC vMotion in vSphere 5 with SQL Server

http://youtu.be/X8AqMhdz3OE

vSphere 5 Storage DRS IO Load Balancing

http://youtu.be/LhaaNCC-GeY

vSphere 5 Storage DRS based on Datastore Capacity Utilization

http://youtu.be/1hFQOFc8coE