Database on different Array and disks | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Database on different Array and disks

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
I think that is fine.
Luis Martin
Moderator
SQL-Server-Performance.com
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.
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
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.
Are you going to put SQL, Oracle and BrightStor on the same cluster? Where to put the files really depend on the usage.
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
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.
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.
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
From SQL Server point of view, in my oppinion is acceptable and safe.
Luis Martin
Moderator
SQL-Server-Performance.com
Great, I would like to thanks everyone for your precious support.
Kind regards.
[8D] Franco
]]>