Tempdb on Cluster

• deucellion

  Say Hey Kid

  Points: 679

  More actions

  August 21, 2007 at 3:54 am

  #153763

  Hi All,

  Currently we're setting up a new Sharepoing cluster.  In the design I was given the tempdb was to reside on a local drive, (d, to enhance performance.  (The d: drive is same make, size, speed etc. on each node of the cluster).  When I try to relocate the tempdb I get an error saying that the d: isn't a cluster resource, which is true!

  Is there anyway around this, can a local drive be defined as a cluster resource???  (I guess maybe not and we will have to position the tempdb on our EMC SAN with the rest of the data files.)

   

• Ian Cook

  SSChasing Mays

  Points: 648

  More actions

  August 21, 2007 at 4:02 am

  #728229

  Hi,

  Local drives can't be declared as a cluster resource, because their not available to each node.

  My cluster works OK with the tempdb on the SAN along with the rest of data files.

  Regards,

  Ian.

• michaela

  SSCertifiable

  Points: 5649

  More actions

  August 21, 2007 at 4:08 am

  #728232

  All system databases must be on a shared disk; tempdb is the most important after master and you would need to carefully set the storage for it.