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 |
|
lazerath
Constraint Violating Yak Guru
343 Posts |
 Posted - 2008-01-10 : 01:53:58
|
| Hey all. To preface, I'm not in any way affiliated with the company or product. Anywho, anyone get a chance to see this thing: http://www.fusionio.comhttp://www.tgdaily.com/content/view/34065/135/As a database guy, I can't wait to get my hands on one. Sure, it has some drawbacks (not suited for clustered operation, requires downtime to install, not available yet...), but it has some MAJOR benefits on paper. The big things I can see are:1.) The most I/O per buck for > 100 GB solutions I can find2.) No mechanical parts!!! Who needs large RAID arrays!3.) Super Low power usage & heat dissipation for relative I/O in disk4.) Did I mention how fast this thing is?!5.) It's small, so you can drop ship it (or physically move it) somewhere if needed in the case of a disaster... much quicker than moving a SAN.The really bad thing is that it seems hard to build a high availability solution around this. However, for a Small/Medium business, technology like this is really exciting.Comments? |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-01-11 : 00:38:11
|
i want one. my hard drive is too loud.
elsasoft.org |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-01-11 : 04:45:11
|
| now that rocks!laptops with this stuff will rock. no more slow 5400 rpm drives..._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
lazerath
Constraint Violating Yak Guru
343 Posts |
Posted - 2008-01-11 : 13:54:07
|
| Capacity is obviously nowhere near that of a standard SAN/enterprise RAID array. In situations that need more capacity that these can offer, you can always supplement with a traditional DAS solution. For me, I would need to do that. I have a couple databases that soak up a lot of space but really don't need to be super fast. If I could just put the main OLTP and ETL databases on this thing it will take my DB server to a whole new level... nay, planet. |
|
|
|
lazerath
Constraint Violating Yak Guru
343 Posts |
Posted - 2009-03-29 : 01:30:42
|
| http://www.tomshardware.com/picturestory/493-8-x25-e-fusion-io-iodrive.html |
|
|
|
lazerath
Constraint Violating Yak Guru
343 Posts |
Posted - 2009-03-29 : 02:05:38
|
| Here's another look at the intel X25-E in a RAID array compared against SAS disks. SQLIO performance:http://it.anandtech.com/IT/showdoc.aspx?i=3532&p=7MySQL DB setup with different array compositions:http://it.anandtech.com/IT/showdoc.aspx?i=3532&p=11 |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
smino
Starting Member
2 Posts |
Posted - 2009-09-09 : 12:41:20
|
| Question is, how would you setup the os, sql and such for best performance using the fusion io? Assume you can only afford the one 80GB one.Sylvain Mino |
|
|
|
|
|
|
|
|
Fusion IO - SSD & You