Microsoft SQL Server Virtualization Through SMB 3.0 on Cisco UCS and a Tegile IntelliFlash Array

Microsoft SQL Server Virtualization Through SMB 3.0 on Cisco UCS and a Tegile IntelliFlash Array

Author: Wen Yang | Tegile Systems

Revision: 1.0

Executive Summary

Microsoft SQL Server Virtualization Through SMB 3.0 on Cisco UCS and a Tegile IntelliFlash Array

Server virtualization has evolved over the past few years from a nascent technology into a mature IT feature. In the process, businesses of all shapes and sizes have begun taking advantage of its power to meet shifting business needs. By virtualizing their workloads, organizations can reduce and control costs while improving the scalability, flexibility, and reach of IT systems. It has becoming a norm for IT organizations to virtualize SQL Server applications.

Microsoft introduced SMB 3.0 network file sharing protocol with Windows Server 2012. With SMB 3.0, for the first time you have the performance and enterprise-class storage capabilities you need to run applications like Hyper-V and SQL Server databases directly using a file protocol.

Businesses depend on Microsoft SQL Server databases for online transaction (OLTP), data warehousing, and analytics workloads. It’s important that SQL Server delivers consistently high levels of performance and availability. But this can be difficult without the right storage infrastructure. As a result, revenue and productivity can suffer.

Tegile offers a comprehensive portfolio of all-flash and hybrid storage solutions that increases transaction throughput by 10x, delivers sub-millisecond latency, and dramatically reduces your storage footprint. Tegile arrays also offer comprehensive enterprise-class data protection and business continuity features at no extra license cost. Furthermore, Tegile is among the forerunners that has native SMB 3.0 network file protocol support and certified for Windows Server 2012/Hyper-V and Microsoft SQL Server.

Implementing a virtualized SQL Server application requires careful planning and validation. With introduction of SMB 3.0 file protocol, you now have more factors to consider when planning your SQL server installation or upgrade.

This document offers a few typical reference architectures of deploying Microsoft Windows Server Hyper-V based SQL Server virtualization using SMB 3.0 protocol on Cisco Unified Compute Server (UCS) and Tegile IntelliFlashTM storage, which can help to save you time when planning your next SQL Server deployment. Typical use cases include: Single Instance SQL Server, SQL Server AlwaysOn Failover Cluster, SQL Server AlwaysOn Availability Group, and SQL Server Mixed Workloads.

The reference architectures in this document are applicable to Microsoft SQL Server 2012, 2014 and 2016 on Windows Server 2012 R2 and onwards.

DOWNLOAD TECHNICAL REPORT (.PDF): 08.24.2016 SQL-HyperV-SMB3-v1-0-authors

Copyright 2016 Tegile Systems. All rights reserved.

Sponsored by Tegile Systems.

You may also like...