SQL Server Performance

Database on different Array and disks

Discussion in 'SQL Server Clustering' started by franco, Feb 16, 2004.

  1. franco New Member

    Future Environment:
    Cluster of 2 node IBM x445 4 CPU 2.0 GHZ 4GB Memory each server.
    1 Controller IBM FastT700 with 2 EXP700.
    26 FC-HDD 74GB 15K in RAID 1 + 2 Hot Spare
    Tape and so on...

    I am in the process of configure this new cluster and I have a question about where to place db files and log files.
    I would like to put 4 dbs on one Array (disk D:) and the 4 log files on another Array (disk E:).
    For internal reason I have been asked if it possible ans safe to put other 2 databases and 2 log files on other different Arrays (disk F: for *.mdf files and disk G: for *.ldf files)
    So , the final design would be:

    4 databases on Array 1 - disk D:4 log files on Array 2 - disk E:2 databases on Array 3 - disk F:2 log files on Array 4 - disk G:
    What can you suggest?
    Any help is really appreciated.
    Thank you for your time.

    Franco
  2. Luis Martin Moderator

    I think that is fine.


    Luis Martin
    Moderator
    SQL-Server-Performance.com
  3. satya Moderator

    What is the projected growth rate of those 4 databases?
    Ensure to maintain regular backups & DBCC checks against the databases to keepup the performance levels.

    If so the current plan will be ideal, and also refer to clustering resources for tips and tricks on this website.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  4. franco New Member

    What can you suggest regarding this question:
    Is it better to put files on different partitions on the same array or place files on different arrays?
    I am aware that placing files on different array would be equal to waste a lot of space.
    Consider that I have to plan this cluster with fc-hdd of 73GB.
    What can you suggest, what is the ideal design for:
    SQL database
    SQL log
    SQL tempdb
    MS-DTC
    ....and more where to put:
    Oracle database
    Oracle redo logs
    Oracle archive logs
    Oracle RMAN backup
    Oracle exports
    ...and more
    CA-BrightStor ArcServe for windows v.11
    file system
    quorum disk.

    Please advise.




    Franco
  5. satya Moderator

    If its a normal application using those databases then go with your option :
    4 databases on Array 1 - disk D:4 log files on Array 2 - disk E:2 databases on Array 3 - disk F:2 log files on Array 4 - disk G:

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  6. Argyle New Member

    Are you going to put SQL, Oracle and BrightStor on the same cluster?

    Where to put the files really depend on the usage.
  7. franco New Member

    Yes, I am going tu put everything on the same cluster.
    One node will host SQL Server and file system.
    The second node will host Oracle.
    CA-Brightstor version 11 for windows in now a fault-tolerant application and it need to be installed on the shared disk of the cluster with the same drive letter assigned to the volume from all nodes.
    The x445 Servers are really powerful, so it is the controller FastT700 and the disk tecnology (FC-HDD 15K).We have 4GB of memory each server and we can expand it if we need it.
    My problem was only related to how many disks will I need to host all my things, and the question is:
    Is it better to have multiple partition on the same array or is it better to have different arrays?
    Thans everyone for the support.


    Franco
  8. satya Moderator

    For the SQL Server part its better to keep apart from other application files, to gain the performance.

    As I refresh my comment above, it really depends on the database growth and corresponding applications sharing the resources.

    Its better to seperate the Oracle & SQL server for the sake of future performance.

    HTH

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  9. Argyle New Member

    Multiple partitions on same array gives no performance boost as far as I know. And you cant use the partitions for different cluster groups either, they have to be in the same group. Go with multiple arrays containing a single partition for the different apps.

    For SQL also go with seperate arrays for data and log. If you have enough disk you could go for seperate array for tempdb and backup. But it depends, say you have 16 disk. Then it might be better to create 2 RAID1+0 arrays with 8 disks each instead of 4 RAID1+0 arrays with 4 disks each if you need the performance. On the other hand mixing apps on same drive can slow down performance as well.
  10. franco New Member

    This is the final idea of my design: 2 EXP700 with 28 FC-HDD:

    Array 1: single partition
    4 HDD in Raid 1 for SQL Server DB
    DISK W:
    Array 2: single partition
    2 HDD in Raid 1 for SQL Server LOGS
    DISK V:
    Array 3: multiple partitions
    2 HDD IN Raid 1 for SQL Server Backup and SQL Server Tempdb
    DISK U:
    DISK T:
    Array 4:multiple partitions
    4 HDD IN RAID 1 for Oracle DB
    DISK S:
    Oracle redo logs
    DISK R:
    Oracle archived logs,
    DISK Q:
    Oracle Exports and Backups
    DISK P:
    Array 5: single partition
    6 HDD in RAID 1 for file system
    DISK O:
    Array 6: multiple partition
    2 HDD in RAID 1 for the QUORUM
    DISK N:
    SQL Server MS-DTC
    DISK M:
    4 HDD for Hot Spare disks.

    Is this acceptable and safe?
    Please advise.
    Regards.




    Franco
  11. Luis Martin Moderator

    From SQL Server point of view, in my oppinion is acceptable and safe.


    Luis Martin
    Moderator
    SQL-Server-Performance.com
  12. franco New Member

    Great, I would like to thanks everyone for your precious support.
    Kind regards.
    [8D]

    Franco

Share This Page