Solved

SATA or SSD for my new server?

Posted on 2012-04-04
3
509 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 500 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

Backup Solution for AWS

Read about how CloudBerry Backup fully integrates your backups with Amazon S3 and Amazon Glacier to provide military-grade encryption and dramatically cut storage costs on any platform.

Question has a verified solution.

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

Lets start to have a small explanation what is VAAI(vStorage API for Array Integration ) and what are the benefits using it. VAAI is an API framework in VMware that enable some Storage tasks. It first presented in ESXi 4.1, but only after 5.x sup…
Each year, investment in cloud platforms grows more than 20% (https://www.immun.io/hubfs/Immunio_2016/Content/Marketing/Cloud-Security-Report-2016.pdf?submissionGuid=a8d80a00-6fee-4b85-81db-a4e28f681762) as an increasing number of companies begin to…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
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…

740 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