?
Solved

SATA or SSD for my new server?

Posted on 2012-04-04
3
Medium Priority
?
514 Views
Last Modified: 2012-05-10
Hello,

I'm planning to migrate my server, I use a Paradox db based software and I wonder If is better to have a SATA3 drive on my server or is better to put a SSD drive to increase the acces/read/write speed.

I'm planning to have a RAID 5 system.

Is there any advantage to use SSD vs SATA on my server?

Thanks a lot and kind regards.
0
Comment
Question by:starbase2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 14

Accepted Solution

by:
JAN PAKULA earned 2000 total points
ID: 37809646
best way would be to use sata 3 ssd - with raid 1 configuration = 2x read speeds , and normal write - which will be about 500 MBs

http://www.ebuyer.com/268244-ocz-120gb-agility-3-ssd-agt3-25sat3-120g-agt3-25sat3-120g

with raid 5 you dont get huge speed performance -you only get redundancy - with raid 1 you have speed (only reads) and redundancy

Jan MA CCNA
0
 
LVL 3

Expert Comment

by:gnemi
ID: 37809674
It depends on the volume of queries your running. Are you running high IOPS that requires the speed of SSD? HDD are cheaper and last longer.

This site has a good comparison with use in postgres, since they are both relation db's you should see similar performance with paradox.

http://it-blog.5amsolutions.com/2010/08/performance-of-postgresql-ssd-vs.html
0
 
LVL 69

Expert Comment

by:Callandor
ID: 37810720
SSDs are affordable up to 256GB, but the price goes up significantly above that.  They are significantly faster than hard drives in random access seeks (about 100x; 0.1 msec vs 8 msec).  To maximize their lifespan by evening out writes, you need to use an OS that supports TRIM, and currently, no hardware RAID controller supports TRIM.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
Is your phone running out of space to hold pictures?  This article will show you quick tips on how to solve this problem.
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question