Home > VMware vSAN > SQL Server 2016 Database Performance and Improvements on vSAN 6.7™
Cancel

SQL Server 2016 Database Performance and Improvements on vSAN 6.7™

This document is a showcase of using vSAN 6.7 all-flash as an HCI for operating and managing SQL Server 2016 in a VMware vSphere® environment.

EXPORT TO PDF vSAN Hands-on Lab

Playlists

Executive Summary

This section covers the executive summary of this guide.

Technology Overview

This section provides an overview of the technologies used in this solution: - VMware vSphere 6.7 - VMware vSAN 6.7 - Microsoft SQL Server 2016 - Samsung NVMe SSD - HCIBench

Solution Configuration

This section describes the solution architecture, hardware and software resources, network configuration, test tools, and the SQL Server and virtual machine configuration used in this solution.

Solution Validation

This section describes the solution validation: - Test tools and configurations - HCIBench performance - SQL Server OLTP performance - Adaptive resync - DB batch insertion performance and improvement

Conclusion

References

Appendix - Batch Insertion Script

About the Author and Contributors