ProLiant Servers (ML,DL,SL)
1748248 Members
3494 Online
108760 Solutions
New Discussion юеВ

Re: DL385 G7 - IO Sub System

 
Jakey1999
Occasional Contributor

DL385 G7 - IO Sub System

Given budget constraints I have a choice of the following IO sub-system options that I wanted to get some opinions/advice on. Both price out about the same for the DL385 G7 running SQL 2005 64bit and within our budget, so at this point IтАЩm more interested in the performance benefit of one option over the other, if any. Here they are:

Option 1:
2 - P410 (one integrated) Controllers with 512MB Flashback Cache;
12 72GB 6G Hot Plug 2.5 SAS Drives:
System Drive - RAID 1;
SQL Log тАУ RAID 1;
SQL Temp DB тАУ RAID 1 (2 disks);
SQL Database тАУ RAID 1+0 (4 disks);
2 online spares тАУ one for each controller.

Option 2:
1 - P410 (one integrated) Controller with 1GB Flashback Cache;
1 тАУ SAS Expander Card;
13 72GB 6G Hot Plug 2.5 SAS Drives:
System Drive - RAID 1;
SQL Log тАУ RAID 1;
SQL Temp DB тАУ RAID 1 (2 disks);
SQL Database тАУ RAID 1+0 (6 disks);
1 online spare.

Please let me know what you think. Thank you.
2 REPLIES 2
Jan Soska
Honored Contributor

Re: DL385 G7 - IO Sub System

Hello, I would prefer option 2. In my opinion 1GB cached p410 should easily stay with load from 13 disks and you get 2 more spindles for real SQL data.

some other thinks:
- what about to use SSD for data? I know there is no real offer from HP, but there are other options with SLC SSD...
- what about put system+ sql log on one hw lun with bigger disks and add another 2 spindles to sql data?

Jan
Jakey1999
Occasional Contributor

Re: DL385 G7 - IO Sub System

Thank you Jan,

We ended up going with option 1 but found money for 2 additional drives. Interesting idea about sharing the system and log drive. I'm just starting to configure the server, so that may be an option. Do you have any recommendation about configuring the P410 controllers for SQL 2005? Thanks.