Microsoft Applications Resources
This page summarizes resources for running and maintaining Microsoft applications workloads on VMware vSphere and SDDC stack. The page will be constantly updated once new resources will be available. The structure of the page is per application and at the end depicting separately resources for maintaining windows server failover cluster (WFCS) and general vSphere documentation relevant to running application workloads.
SQL Server on VMware: Resources Guide
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