| |
| Publicado el 04,noviembre 2014 - 21:48 |
Hi,
has anybody experience with SSDs in a real server for HF SQL(if yes which RAID Level ?)
Makes it sense, how much better is the performance compared to 15k SAS HDD´s ? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 04,noviembre 2014 - 22:03 |
Hi Michael
I saw the difference between a high end SSD and a high end HD and the difference is just AMAZING... We are really talking about 10x faster here, at least... However, a LOW END SSD is not giving anything more than 10% improvement
As for the RAID, I do not think there was any involved in that test, but I may be wrong
Best regards |
| |
| |
| | | |
|
| | |
| |
| Publicado el 05,noviembre 2014 - 06:21 |
| I run a Sheriff's Department 911 Com center off of SSD only. . |
| |
| |
| | | |
|
| | |
| |
| Publicado el 05,noviembre 2014 - 07:10 |
| |
| |
| | | |
|
| | |
| |
| Publicado el 08,noviembre 2014 - 14:11 |
Michael
We do have 2 different i5-CPU running Win7 on LAN with 2-SSD (RAID-1)
loaded with c/s HFSQL but didn't test out the performance, will do when
have time. The SSD performance test is 450 MBytes/sec.
But we have 2-intel2620CPU with 2-EnterpriseClass-Intel-SSD (200GB each) on Linux Centos running with RAID-1 (HP RAID controller on HP Gen8 server) and
the performance test is 950MBytes with 0.3 ms access time.
As I found it hard-time to install HFSQL, will resume when I have time, pcsoft
recommends Ubuntu/Debian. We are running Progress database and the
test result is 20x than we had the database with old HP Server with SAS and
each table has min 20 million records. We are running avg 70/30GB read/written
each day, extremely stable. We have 3-yr warranty of SSD from HP.
we bought @$3000up per 200GB HP Enterprise SSD.
ie. good RAID controller card is matter as we have DELL RAID Controller card
with 2-SSD in RAID-1 ending up with 450MB /s in comparing with HP Controller
card resulting in 950MBytes/s.
HTH
Cheers
King |
| |
| |
| | | |
|
| | |
| |
| Publicado el 08,noviembre 2014 - 14:34 |
Hi King,
thx for your answer.
We buy our server completly from DELL. I just take a look at the online configuration website and it puts me the tears in my eyes. One Hispeed SSD 400 GB = 1.600 €. That´s for the moment to expensive .... |
| |
| |
| | | |
|
| | |
| |
| Publicado el 10,noviembre 2014 - 14:26 |
Hi guys,
Just to share a bit of experience when you buy a DELL RAID controller card: get a second one when you buy the server in backup just in case the controller fails.
We had a DELL server and after 5 years (if my memory is good) our RAID controller failed. We lost all data on the disks and nobody was able to recover it. Reason? It was not possible to read the HDs without the controller card. Also, it was not possible to get a new controller from DELL (to be exactly the same - we were being told that it had to be the same): the model was too old.
So if you are in the RAID thing, make sure to "RAID your RAID controller", so to say, in buying one more just in case the first one fails.
Maybe things could have been different, and are now different, but this is what happened to us back in that time. It was a hard lesson. We never thought that the controller card could fail before the HDs!
Best regards,
Alexandre Leclerc |
| |
| |
| | | |
|
| | |
| |
| Publicado el 10,noviembre 2014 - 15:00 |
Hi Alexandre
Thx for the share. I'll get a backup RAID controller card for just in case and
I wonder if you're using it with SAS, SSD or something else.
Cheers
King |
| |
| |
| | | |
|
| | |
| |
| Publicado el 10,noviembre 2014 - 15:04 |
Michael
What brand and it's far cheaper than I bought for CAD$3000 of 200GB only?
FYI: Top server is HP (Compaq eng. team), 2nd is CISCO but I don't the ranking for DELL.
Cheers
King |
| |
| |
| | | |
|
| | |
| |
| Publicado el 10,noviembre 2014 - 15:37 |
Hi King,
I don´t know, I think they are DELL branded (like all HDDs in the server)
We have very good experience with the DELL server support, the guys are very good and friendly.
For all server in our productive enviroment we have a 4 hour mission critical contract.
That means that all spare parts are availible in 4 hours ...
I hope for me (and for DELL) that the have enough RAID controllers for the runtime of this contract .... |
| |
| |
| | | |
|
| | |
| |
| Publicado el 11,noviembre 2014 - 08:45 |
Mr king if you need we can help you out if you need help.
mark is the name
Whiteriverservices.com |
| |
| |
| | | |
|
| | |
| |
| Publicado el 12,noviembre 2014 - 19:35 |
| What about that of SSDs having a limited number of Writes on the same area ? |
| |
| |
| | | |
|
| | |
| |
| Publicado el 13,noviembre 2014 - 06:40 |
Technology is always short time, as soon as the SSD drives we are using can last long
4 to 5 years is good to go and I'm sure it's worth to buy a new one 4/5 years for
replacement in terms of speed/capacity. At least, it can enhance the speed with 20x
is the deal and it warrants to swap out within 3 yrs if the drive is dead.
No worries.
King |
| |
| |
| | | |
|
| | |
| |
| Publicado el 13,noviembre 2014 - 06:49 |
NP Mark. I keep your URL and give you a shout if the drive is dead.
thx
King |
| |
| |
| | | |
|
| | |