Microsoft SQL Server On VMware Best Practices Guide Available Here!
-
Architecture
- Architecting Microsoft SQL Server on VMware vSphere®. Best practices guide
- Microsoft SQL Server on VMware vSphere® Availability and Recovery Options
- Planning highly available, mission critical SQL server deployments with VMware vSphere –
- SQL Server FCI and File Server on VMware vSAN 6.7 using iSCSI Service
Performance
- Performance characterization of Microsoft SQL Server on VMware vSphere 6.5
- Using Persistent memory with a virtual Microsoft SQL Server
- VMDK versus RDM performance study
SQL Server on VMware Cloud on AWS
SQL Server Licensing
Configuration Considerations
- Frank Deneman. NUMA Deep Dive Series
- Configuring disks to use VMware Paravirtual SCSI (PVSCSI) adapters
- Large-scale workloads with intensive I/O patterns might require queue depths significantly greater than Paravirtual SCSI default values
- Upgrading a virtual machine to the latest hardware version
- Cornac Hogan, When and why do we “stun” a virtual machine
- Understanding VM snapshots in ESXi / ESX
- A snapshot removal can stop a virtual machine for long time
- Virtual machine becomes unresponsive or inactive when taking a snapshot
SQL Server Specific Resources
- Compute capacity limits by edition of SQL Server
- Editions and supported features of SQL Server 2017
- SQL Server Memory Management Architecture Guide
- Operating System Best Practice Configurations for SQL Server
- Description of support for network database files in SQL Server
- SQL Server Soft-NUMA feature
- SQL Server 2016 – It Just Runs Faster: Automatic Soft NUMA
- How It Works: Soft NUMA, I/O Completion Thread, Lazy Writer Workers and Memory Nodes
- SQL Server and Large Pages Explained
- Transaction Commit latency acceleration using Storage Class Memory in Windows Server 2016/SQL Server 2016 SP1
- How It Works (It Just Runs Faster): Non-Volatile Memory SQL Server Tail Of Log Caching on NVDIMM
- Virtualization-based Security (VBS)
WINDOWS FAILOVER CLUSTER SERVICE (WFCS) SUPPORT ON VMWARE VSPHERE
- VMware kb: Guidelines for Microsoft Clustering on vSphere
- Setup for Failover Clustering and Microsoft Cluster Service
- Support for Windows Failover Clustering on VMware Cloud on AWS
- ESXi/ESX hosts with visibility to RDM LUNs being used by WFCS nodes with RDMs may take a long time to start or during LUN rescan (Configuring perennially reserved flag)
VSPHERE DOCUMENTATION
- Understanding Memory Management in VMware vSphere 5
- VMware Tools
- VMware vCenter Server and Host Management
- vSphere Availability 6.5
- vSphere Resource Management. vSphere 6.7
- vSphere Security. vSphere 6.7
vSphere Performance Study
Wish you all the best.