network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 3 years, 9 months |
| seen | Sep 3 '10 at 17:45 | |
| stats | profile views | 6 |
|
Nov 29 |
awarded | Notable Question |
|
Jul 24 |
awarded | Popular Question |
|
Sep 1 |
awarded | Scholar |
|
Sep 1 |
accepted | Setting up array of SSDs for Oracle Database, recommendations? |
|
Sep 1 |
comment |
Setting up array of SSDs for Oracle Database, recommendations? Thanks for the link. Since the workload here is very biased toward read, the disks will be used exclusively for this DB, and the space doesn't really matter, Both R5 and R10 are viable options. My testing seems to suggest that the controller is not very good at RAID 5, and I see ~15% lower performance using it. I think R10 will be my choice. |
|
Aug 31 |
comment |
Setting up array of SSDs for Oracle Database, recommendations? Assuming the controller will read from all members of a RAID 10. I've read things that seem to suggest that the P400 does not. I can't seem to find any of those things right now, but I also can't find anything that says it for sure does. I think my very first bottleneck will be that the P400 only supports SATA1 (1.5Gbps). So even in RAID 0 and some kind of magic that allows me to fully saturate that, I'll never see more than ~900MB/sec from 6 drives. PCIe x8 should give me the ability to move double that. |
|
Aug 31 |
revised |
Setting up array of SSDs for Oracle Database, recommendations? added 86 characters in body |
|
Aug 31 |
comment |
Setting up array of SSDs for Oracle Database, recommendations? I think you're suggesting running the database in memory rather than on SSD. This was looked at as well, and shot down by my DBAs, but I didn't push it with them. If you have any links for best practices/tutorials on running the DB in memory, I might be able to do so. The server does have 24GB of RAM, and I beleive there are at least 3 slots left. I'm not sure where you're finding 64GB of DDR3 for $1000 unless prices have dropped significantly in the last couple of weeks. 4GB DIMMS are under $300, but you'd still need 16 of them for 64GB, difficult with only 9 slots per CPU (1 cpu box). |
|
Aug 31 |
revised |
Setting up array of SSDs for Oracle Database, recommendations? deleted 3 characters in body |
|
Aug 31 |
awarded | Editor |
|
Aug 31 |
comment |
Setting up array of SSDs for Oracle Database, recommendations? Thanks. Most of what I've found from Oracle has been either older information for DRAM based SSD, or information specific to running on their shiny newly acquired SUN hardware. I didn't think to look for MS SQL tuning info, but so long as I can translate Windows-Linux, you're right that the data should hold true. |
|
Aug 31 |
revised |
Setting up array of SSDs for Oracle Database, recommendations? added 5777 characters in body |
|
Aug 31 |
answered | Putting Oracle redo logs on DRAM SSD for a heavy write database? |
|
Aug 31 |
awarded | Supporter |
|
Aug 31 |
asked | Setting up array of SSDs for Oracle Database, recommendations? |
|
Sep 15 |
awarded | Student |
|
Sep 15 |
awarded | Teacher |
|
Sep 15 |
answered | Is there a way to check to see if your VMFS partitions are aligned on storage? |
|
Sep 15 |
asked | Is there a way to check to see if your VMFS partitions are aligned on storage? |
