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.
| Author |
Topic |
|
infrb
Starting Member
2 Posts |
 Posted - 2008-11-26 : 02:41:16
|
| I have a server with 48 disks. 20 of those disks will be setup for SQL. The specs of the server are.HP DL585 G5128GB of RAM48 146GB SAS Drives (8 internal, 40 external)20 of those disks will be used for SQL on one P800 ControllerAnother 20 will be used for another partition running another product that feeds into the SQL database8 disks will be internal using its own P800 ControllerFor disk design I'm thinking of:C (8 disks in RAID 10): OSD (20 disks RAID 10): Other productE (20 disks RAID 10): SQLSince all three drives are on their own separate array controllers, do I need to carve out separate partitions for Logs and TempDB? Isn't the bottleneck here the array controller, hence if I made separate RAID 10 arrays on the same controllers I wouldn't be getting any benefit of moving the logs and tempdb to another drive? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-26 : 11:20:28
|
| I would put TEMPDB and log files on its own partition. |
 |
|
|
infrb
Starting Member
2 Posts |
Posted - 2008-11-26 : 14:19:54
|
| And in doing so, where should i be pulling those drives from? I can't pull them from the D:. So pull them from the 8 disks on C:? In essence giving me...C: 4 disks in RAID 10T (TempDB): 2 disks in RAID 10L (Logs): 2 disks in RAID 10 |
|
|
|
|
|
|
Question about hardware design