SQL Server Performance

Sharing Storage - What must be shared?

Discussion in 'SQL Server Clustering' started by DBADave, Apr 26, 2007.

  1. DBADave New Member

    I'm new to clustering and have just begun to research how to configure a SQL Server cluster. I know we want to have our data and logs on a SAN. What about tempdb and backups? I like to separate tempdb from data and log drives and I also like to backup databases to a dedicated drive. With a cluster, must tempdb and backups also be on the SAN?

    Also, can someone save me a few minutes and point me to a good link for configuring a SQL cluster?

    Thanks, Dave
  2. Argyle New Member

  3. bradmcgehee New Member

    SANs vary from one model to another. In some SANS, you might be able to dedicate specific RAIDed drives for specific purposes, such as mdb, ldf, tempdb, and backups. On other SANS, disks are virtualized and you just carve out a logical section instead of specifying exactly which drives will be used for what specific purpose.

    --------------------------------
    Brad M. McGehee, SQL Server MVP
    http://www.sqlbrad.com
  4. Raulie New Member

    Put all Databases on the SAN, like Brad mentioned depending on the SAN you can place TempDB and TLogs on seperate RAID arrays, go with RAID 10 when ever possible otherwise place TempDB and TLogs on RAID 1. You can place backups on the SAN as well, we backup all our databases to disk then from disk directly to tape.

    Raulie



Share This Page