1

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.

migrated from stackoverflow.com Jan 24 '17 at 20:49

This question came from our site for professional and enthusiast programmers.

0

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

  • Does that mean each node has to have a VHD for each VM within the cluster? What happens if we run out of local storage, especially when most of the VHDs aren't in use on the specific node? – DARKOCEAN Jan 25 '17 at 9:09
  • Yes that's correct. You just have to manage storage the best way possible. If you want the TempDB to reside on local storage in a cluster, matching the paths on all nodes is the only way for this to work. – JAY Jan 25 '17 at 18:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.