Clustering Setup

• free_mascot

  One Orange Chip

  Points: 27164

  More actions

  Follow

  November 24, 2008 at 11:55 pm

  #127083

  Good day,

  I am trying to setup avtive/passive Database cluster environment on 2 Box with SAN and RAID10. I need clarification on the following:

  1. Can I put log & Tempdb on local drive? If yes, failover will work smoothly? does it take moretime?

  2. MS DTC can be installed on local drive?

  3. If Data, Log and TempDB should be on SAN;

  can we put all three into one Drive i.e. SAN F:

  or

  for Data SAN F:, Log SAN G:, TempDB SAN H:.

  Which setting would be ideal? Pl. Justify.

  Thank you in advance,

  FM

  ---------------------------------------------------
  "Thare are only 10 types of people in the world:
  Those who understand binary, and those who don't."

• Elisabeth Rédei

  Hall of Fame

  Points: 3873

  More actions

  November 25, 2008 at 12:28 am

  #902949

  Hi,

  1. No, everything has to go on the shared drives (except binaries i.e. Program Files) otherwise the databases are not accessible from both nodes.

  2. No, the MSDTC log has to reside on a shared drive as well. Which version of the OS are you running on? (If Windows 2003, have a look at http://support.microsoft.com/?kbid=301600 and support.microsoft.com/kb/817064).

  3. Technically you can put them all on the same drive but from performance perspective you will be happier to have separate IO paths for them.

  There is a whitepaper "Physical Database Storage Design" which has a list of general recommendations for you physical storage: http://www.microsoft.com/technet/prodtechnol/sql/2005/physdbstor.mspx.

  HTH

  /Elisaeth

  elisabeth@sqlserverland.com
  MCITP | MCT
  http://sqlblog.com/blogs/elisabeth_redei/
  http://linkedin.com/in/elisabethredei

• free_mascot

  One Orange Chip

  Points: 27164

  More actions

  Follow

  November 25, 2008 at 2:16 am

  #902970

  Hello Elisabeth,

  Thanks a lot for quick turn around. Your answer is perfect that's what I was looking for.

  I have the same openion like you but customer make me confuse :w00t:. Your answer gave me higher degree of confidence. I have rade your earlier article on Cluster soultion and found it very informative.

  Cheers...

  FM

  ---------------------------------------------------
  "Thare are only 10 types of people in the world:
  Those who understand binary, and those who don't."