Microsoft SQL Server 2012 Reference Architecture

This document provides a reference architecture for deploying Microsoft SQL Server 2012 on the Pure Storage FlashArray. This document includes planning recommendations, configuration best practices as well as performance findings. This reference architecture has been validated against:

  • Microsoft Windows Server 2012 R2, Data Center Edition (64-bit)
  • Microsoft SQL Server 2012 Enterprise (64-bit), Service Pack 1
  • Pure Storage FlashArray 420 (FA-420)
  • Purity Operating Environment 4.0.0

Although this reference architecture has been validated against Microsoft SQL Server 2012, previous versions such as SQL Server 2008 and SQL Server 2008 R2 Service Pack 1 are supported.