While working through my new demos for SQL Server 2016 on Windows Server 2016 I had to rebuild my hyper-converged SQL Failover Cluster environment using local storage and Storage Spaces Direct for the cluster shared storage instead of configuring a iSCSI SAN environment or SMB File Share as I have done in the past. However, there is a catch with the virtual disks under VMware Workstation by default, they don’t expose the SerialNumber which is required for S2D to be able to use the drives in the pool. In PowerShell, Get-PhysicalDisk on a new VMware Workstation VM looks like this:
To fix the issue, the VMX file for the VM must be modified to add the following line:
disk.EnableUUID=”true”
Once the VM is rebooted, the SerialNumber is populated in Powershell for Get-PhysicalDisk, and S2D will be able to use the disks in the storage pool.
Related Posts
- An XEvent a Day (18 of 31) – A Look at Backup Internals and How to Track Backup and Restore Throughput (Part 2)
- Tracking Problematic Pages Splits in SQL Server 2012 Extended Events – No Really This Time!
- SQL Sentry Plan Explorer Completely Free!
- Graphically Viewing Extended Events Deadlock Graphs
- An XEvent a Day (29 of 31) – The Future – Looking at Database Startup in Denali