SQL Server Performance

a/p cluster disklayout

Discussion in 'SQL Server Clustering' started by acki4711, Jan 11, 2006.

  1. acki4711 Member

    Hi all,
    I'm designing a active/passive 2 node clustering solution on Windows 2003 Enterprise and SQL Server 2000 Enterprise and I'm a bit confused on the disklayout.
    Designidea as follows:

    C: OS, Local Disk RAID 1
    D: SQL Srv. binaries, Local disk RAID 1
    E: SQL Srv. system db's, FC SAN RAID 1+0 (master, model, msdb, tempdb)
    F: user db's, FC SAN RAID 5
    G: user db's logfiles, FC SAN RAID 1+0
    H: backup of all db's, FC SAN RAID 5
    Q: quorum disk, FC SAN RAID 1+0

    Questions:
    - is it a good idea to put the sql srv. system db's on a SAN disk? or is it better (or necessary) to keep them on a local disk?
    - does the quorum disk need to be on the SAN?

    Any help to the questions or other suggestions are highly appreciated.
    TIA
    Dan Ackermann

  2. Argyle New Member

    All databses have to be on SAN. Quorum has to be on SAN.

    The only thing on local disk are OS and the SQL binaries.

Share This Page