Sql-server – Understanding disk requirement to make fail over cluster

clusteringfailoversansql-server-2012

Please take a look at the following screenshot.

enter image description here

I am trying to make SQL Server 2012 Fail Over Cluster using two nodes. As you know we need to have a shared SAN which will be used by both nodes to store data but I have some confusion regarding it.

I was under the impression that we need one drive for e.g. Z for "Temp DB directory" which will be shared by both nodes to store data.

But someone told me that these will be two drives actually for each node and for these nodes it will appear as one. So I am not sure what is true. May be we are both saying same thing!?

Best Answer

In a cluster TempDB absolutely would be on shared storage, and ideally it would be separated from other shared storage.

A basic SAN template to follow would be (minimums):

  • Volume for data files
  • Volume for transaction logs
  • Volume for TempDB
  • Volume for backups

This is a very basic, bare minimum config. There are numerous "Depends on..." considerations. Check out Brent Ozar's article on SAN Storage for much more detail.

Related Question