Database on different Array and disks

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Database on different Array and disks

Author

Topic

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2004-02-16 : 08:41:01

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

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-02-16 : 12:42:34

Yes that would be fine. The key thing is that the log file isn't located on the same array as the database file.

How big are these databases going to be? I'm wondering if 4GB is enough for memory.

Tara

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2004-02-16 : 15:23:21

I receive your answer on my cell phone...here it is 9PM and I am at home.This is great.So the biggest db would be approximately 600MB and the other something like 200-300 maximum.On the other node I will running one Oracle instance.This node will also have 4GB of memory.
Thank you for your time.
Kind regards.

Franco

JohnDeere
Posting Yak Master

191 Posts

Posted - 2004-02-16 : 21:59:16

You should also condsider where you are going to place the tempdb. It is best if it can be placed on its own array as well. You did not mention how you are going to backup the databases. If you are using local disk consider a separate array or at least use the array with the least database activity to store your backups.

Lance Harra

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-02-16 : 22:11:44

4GB is probably going to be enough since your databases are relatively small.

Tara

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2004-02-17 : 01:59:58

I have plan to use a dedicated Array also for native SQL Server Backups.
Next I will copy the backup files on tape and copy the backup files and transaction log files backup (1 every hour) on another server...just in case something really bad happen.
For tempdb I have no plan, do you think it is critical to put this file on a dedicated Array too?
Thanks again for your support.
Kind regards.

Franco

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2004-02-17 : 02:33:45

quote:
Originally posted by franco
do you think it is critical to put this file on a dedicated Array too?

for optimal performance yes. Also, use 15k disks if possible on all arrays - especially the tempdb array.

-update-

I just read your post again and you are using all 73GB 15K disks. You may want to get some smaller capacity disks for the tempdb and logfile arrays so you don't waste a bunch of space.

Also, how are you planning on carving out your drive space? Are you going to be creating separate arrays for each drive letter, or are you going to be creating separate partitions from one big array for each drive?

-ec

franco
Constraint Violating Yak Guru

255 Posts

Posted - 2004-02-17 : 05:01:03

The idea is to create separate arrays for each drive letter.
In fact I have to plan these resources:
Arrays:
1 SQL Server databases
2 SQL Server transaction logs
3 SQL Server backups
4 SQL Server tempdb
5 Oracle database
6 Oracle redo logs
7 Oracle archived redo logs
8 Oracle Exports and Backup (RMAN)
9 File system
10 Ca-BrightStore arcServe Backup for Windows v.11
11 Quorum disk (for the cluster)

Every Array would have a different letter.

I know that I am going to waste space but I need to have the Hot Spare disks able to be bring online if a failure occurs for some drives.
To have the same disk capacity could be critical, so I decide to have all the FC-HDD to be the same dimension.
Thank you for your suggestion.
Kind regards.

Franco

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources