@TheBiznes I take it you currently have 512mb cache did you get one of the 1880s with exchangable ram? On the other forum I linked to the some guys have upgraded to 4gb ram with massive speeds.
You can check out this thread for some impressive numbers.
http://www.xtremesystems.org/forums/showthread.php?t=258008
But the fastest subsystems seem to be an Areca 1880ix series raid controller with 4gb cache and as many ssds as you can throw at it. Currently SF , C300 or Intel (x25-e or...
wouldn't have thought so , as it isn't a raid card. So unless you plan on using windows and building a software raid it won't work. To get true 6gb/s raid look to an appropriate raid card like the lsi 9260-4i, 9260-8i
Real world performance depends on how compressible/compressed the data being written/read is. Highly compressible data (text etc) , like atto uses, does well, uncompressible data (mp3, jpeg etc) not so well.
lsi 9260-4i (or 8i if you may want to increase beyond 4 drives without an expander)
Benefits are typically faster speed + off loading calculations from cpu. Onboard cache means writes can be super quick (when smaller than the cache). Also write advantages can be protected with battery backup...
alternatively if you want a large amount of storage you could try the lsi 9260-8i with some 2TB drives and then add a number of ssd to use as cache using lsi cachecade add on. I have seen people going from 250 iops to 15000 iops using this method.
This is a great thread if you want to see what you can achieve using the lsi 9260-8i
http://www.ocztechnologyforum.com/forum/showthread.php?60466-LSI-9260-8i
Originally getting 1700MB/s with 8 * 30GB vertex. (See post 73)
the guy has also recently installed the fastpath software and now...
I think the problem is that the hard disk controller on the amd boards aren't as fast as the intel (ICH10R) controller. To get the full speed you may need an intel board or a separate raid card.
The truth will be somewhere in between, as the sandforce drives compress data before writing it to the disc. The easier it can be compressed the faster it will effectively write. Therefore depending on the test pattern the benchmark uses and how effectively it can be compressed you will see...
On the OCZ forum Tony states http://www.ocztechnologyforum.com/forum/showthread.php?71593-VERTEX-2-PRO-BEING-RELEASED "Now you have all the facts you must decide what you want from a drive, LE is NOT as fast as 1500 and does NOT have the feature set 1500 has BUT is much like a 1200 BUT it is...
Make sure indexes are correct, you should only see hash joins if queries use > 5% of tables.
Check pl/sql. Most big problems come from there.
Redo, redo ,redo. Your database will only be fast if you can write/archive redo very quick.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.