patternMinor
SSDs with Oracle
Viewed 0 times
withoraclessds
Problem
We've been looking into using SSDs with Oracle to speed up our test migration runs. It currently takes 12-18 hours to complete a migration run, depnding on the volume of data (we're obviously doing lots of performance tweaking too). We've a number of cheap linux boxes we're using for various runs and analysis.
The cost of SSDs direct from Dell is prohibitive. I was wondering if anyone has experience of using consumer SSDs (such as the Crucial/Micron ones).
I realise TRIM support would be an issue on Linux (using Centos). Has anyone used them on Windows 7 to counter this?
The cost of SSDs direct from Dell is prohibitive. I was wondering if anyone has experience of using consumer SSDs (such as the Crucial/Micron ones).
I realise TRIM support would be an issue on Linux (using Centos). Has anyone used them on Windows 7 to counter this?
Solution
I don't see any answers to your question yet, and while I don't have any experience with using consumer grade SSD drives with a database, I thought the following question on ServerFault might be useful:
https://serverfault.com/questions/69037/configuring-sql-for-optimal-performance-ssd-or-hdd
edit: I found the following article recently and thought I'd add it to my answer. It talks about using SSDs with SQL Server, but I thought some of the factors discussed might be useful for Oracle DBAs as well.
http://technet.microsoft.com/en-us/magazine/hh334997.aspx (Reduce I/O, Increase Performance)
https://serverfault.com/questions/69037/configuring-sql-for-optimal-performance-ssd-or-hdd
edit: I found the following article recently and thought I'd add it to my answer. It talks about using SSDs with SQL Server, but I thought some of the factors discussed might be useful for Oracle DBAs as well.
http://technet.microsoft.com/en-us/magazine/hh334997.aspx (Reduce I/O, Increase Performance)
Context
StackExchange Database Administrators Q#573, answer score: 7
Revisions (0)
No revisions yet.