Post reply

Tempdb placement on SQL Cluster, hack to use local array instead of shared??

  • August 14, 2009 at 2:25 pm

    #209426

    Is anyone aware of a trick to get a SQL cluster to place the tempdb on a local array instead of the shared array? Let's say I have drive T: on both Node1 and Node2. I want to map the tempdb to this drive. In the event of a failover from Node1 to Node2, I would assume that the tempdb would be created on the T: drive on Node2 when the SQL Service starts up.

    This would buy me some more space on my shared array if I can pull it off. How can I fool the Cluster Administrator??

    Thanks

  • August 14, 2009 at 2:44 pm

    #1039714

    In a clustered installation, all databases must be on shared storage and those drives must be set as dependencies of the SQL Service (ie cluster resources themselves).

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 14, 2009 at 6:10 pm

    #1039753

    I understand that is the general rule, but I'm wondering if there is a way to trick the cluster service to recognize a local drive as a dependency?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply