SQL Server – TempDB on Local SSDs with VMs

sql serversql-server-2016tempdbwindowswindows-server

Two physical Servers in a Cluster. Multiple SQL 2016 Virtual Machines. Fibre Channel SAN Storage used for the Virtual Machine Operating System and Database Data Files. I've seen multiple sources claim that using local SSDs for the TempDB is best practice.

How should the Local Storage be presented to the Virtual Machine for the TempDB? If the Virtual Machine migrates within the cluster, it will lose the virtual hard drive. How can this best practice be implemented with the above scenario.

Best Answer

You have to specify the same local storage paths on both nodes for the TempDB in order for the nodes to fail over properly.