I should add that we have one client uses who uses Raid 10 SSDs and they process their live DB in about 60 mins (down from about 4.5 hours). Their server cost was US 40k I believe.
On 29 January 2014 17:09, Preet Sangha <[email protected]> wrote: > I got it about 2.5 years ago. > > As part of our dev we process SQL Server Analysis Services databases. The > process will max your CPU/Memory/Disk IO and ask for more! > > - On our server it took 25 mins (16Gb, top of the range sandy bridge > I7 or top , 4x Sata II SSDs in Raid 0) > - On my laptop it took about 15 mins. > - On a typical client site with SAN storage it took upwards of 5 hours. > > Any we've optimised the process considerably since then then and I can > process the cube in about 10 mins now. I don't even do it that often now > either :-) > > I certainly agree that sitting around waiting for stuff to happen in a > real pain and I would never go back to slow machines for anything. > > > > > On 29 January 2014 16:21, Ken Schaefer <[email protected]> wrote: > >> I had something similar in my Sony Z1, but with SATA3 pretty common >> these days, I'm not sure the average single-user machine would see much >> benefit from 2 x SATA3 drives in RAID0 vs just single a single SSD. How >> much data do you load (or save)? >> >> >> >> Cheers >> >> Ken >> >> >> >> *From:* [email protected] [mailto: >> [email protected]] *On Behalf Of *Preet Sangha >> *Sent:* Wednesday, 29 January 2014 2:10 PM >> *To:* ozDotNet >> *Subject:* Re: [OT] Raid 0 >> >> >> >> I have two super fast SSDs running in Raid 0 on my laptop. >> >> >> >> On 29 January 2014 15:30, Ken Schaefer <[email protected]> wrote: >> >> RAID0's usually used for speed, when you don't care about protecting >> the underlying content (e.g. it's ephemeral or you've got it protected >> somewhere else). I think SSDs have eliminated the need for RAID0 on most >> single user machines. >> >> >> >> Cheers >> >> Ken >> >> >> >> *From:* [email protected] [mailto: >> [email protected]] *On Behalf Of *[email protected] >> *Sent:* Wednesday, 29 January 2014 1:27 PM >> *To:* 'ozDotNet' >> *Subject:* [OT] Raid 0 >> >> >> >> Anyone using raid 0 for their dev machine? I have a raid card with 4 >> drives and deciding on whether to use 2 drives in RAID 0 and 2 drives in >> Raid 1 >> >> >> >> >> > > > > -- > regards, > Preet, Overlooking the Ocean, Auckland > -- regards, Preet, Overlooking the Ocean, Auckland
