Welcome to the #StorageMinute series where we deliver key topics via bite-size content.

Microsoft SQL Server

In this edition, we look at how vSAN is an ideal platform for Microsoft SQL Server. While applications are the very reason why a data center exists in the first place, the platform that makes up that data center plays a key part in meeting the needs of business-critical applications like SQL Server. Is the platform easy to use? Can the environment scale well? Will it meet the specific performance and resilience needs of the application and its data? These are the types of questions that should be asked when determining what type of solution will work best for a platform.

How does it work?

SQL server is often responsible for providing the data to transaction-oriented applications. SQL environments often need to ensure levels of consistency, and the ability to scale up or out based on the evolving performance requirements of an organization. These needs align perfectly with vSAN. Storage policy-based management will allow an administrator to prescriptively assign individual database or transaction log volumes to their own specific requirements, and do so with ease and agility, making future modifications simple. Since vSAN provides storage services defined entirely in software, IT teams can introduce new hardware technology incrementally, such as adding newer and faster NVMe flash devices to the hosts that comprise a vSAN cluster. Ongoing improvements in vSAN also mean that new capabilities in performance, usability, and resilience, are only a quick update away, and using the software you already know. For more information on this topic, see the Solution Brief titled "Microsoft SQL Server on VMware vSAN."