SAS reasonable price and reliable

Posted on 2011-09-13
Last Modified: 2012-08-13
I would like to take a progress database and place it on 4 solid state drives in raid 10.  All the bays in my power edge 2950 are full and they are 3.5" drives anyway so replacing them is not an option.  I would just like to know what is a reliable yet reasonably price sas solution to place my solid state drives in to run my database from.  My database is only 4 gigs in size but would like the drive volume to be at least 50 gigs by the time the raid is setup.  Any ideas or recommendations would be greatly appreciated.
Question by:fasse
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
  • 4
  • 2
LVL 18

Expert Comment

ID: 36535529
Why don't you mount your db on a 8GB server to allow all data to stay in RAM ?
If your current Progress release handles only a 32bit process, you should try to upgrade to a 64bit one (I think it's 64bit compatible since OpenEdge 10.1b)
LVL 69

Expert Comment

ID: 36535833
As far as I know, SSDs come with SATA interfaces, but if you have a SAS controller, they will be compatible.  There are enterprise class SSDs and consumer grade SSDs, with prices that are very different, so you will have to decide which you want to go with.  This paper describes the reasons:  Also look at

Enterprise class SSDs are on the order of thousands of dollars, while consumer grade SSDs are in the order of hundreds of dollars.  You can buy PCIe slot mounted drives, internal drives or external drives.  A single 60GB consumer grade SSD costs about $130, but SSDs in RAID arrays do not have TRIM support from the OS yet, which is critical for maximum performance.
LVL 18

Expert Comment

ID: 36535884
All sectors in database files are UPDATED where TRIM only cares of informing the SSD controller of DELETED sectors. You should only take care of storing the LOG files out of the SSD to avoid needing this TRIM support.

Last one, if you can't upgrade to a 64bit OpenEdge release, you may install a PCIe x8 Enterprise SSD like the OCZ VeloDrive
Manage your data center from practically anywhere

The KN8164V features HD resolution of 1920 x 1200, FIPS 140-2 with level 1 security standards and virtual media transmissions at twice the speed. Built for reliability, the KN series provides local console and remote over IP access, ensuring 24/7 availability to all servers.


Author Comment

ID: 36536333
I know this is probably not the best way to look at this but is there somewhat of a equaling factor of quality vs quantity.

1 or 2 enterprise drives thousands.
4 or more standard in raid 10 a $1000

I have thought about running the whole db in ram but our consultant said that we would truly see a 10X increase in speed if we can get the software and the db installed to a solid state drive.

LVL 18

Accepted Solution

BigSchmuh earned 500 total points
ID: 36536692
Well, if all your data are in RAM, a "10x increase in speed" is going to be a small increase.

Appart from that, if you already have a 64bit edition of OpenEdge, I would suggest 2 scenario:
1/ All in RAM
-Upgrade to 8GB minimum
-Allocating enough memory for all the data + index + 20% to stay in RAM
-Arrange a warmup script (a simple "select *" on all tables) to allow filling up all the cache

2/ 2x SSD in a PCIe slot with LOGs on existing HDD
-Check the form factor compatibility for 2x SSD PCIe (with riser card ?)
-Add 2x SSD PCIe like the OCZ RevoDrive X2 100GB $360
-Move your data, index, temp files on it

Author Comment

ID: 36537234
We have been thinking about this more and more.  We have a poweredge 2950 with scsi backplane.  Would it be possible to change out the backplane and install a sata one that would then allow us to use the 2.5"  ssd in our drive cage on the server.  We are looking at this as an opportunity to upgrade the drive for our operating system as well.  We would change out all six drives and replace with ssd.  I have seen the backplanes on ebay for 100 or less like the ones listed below.  Is this all we would have to change on the server side to be able to use the ssd's.  This machine is a quad core, quad processor with lots of power.  We do hate to use an aftermarket device that would not give us the throughput that the machine is capable of.  

ebay 2950 sata backplane
LVL 18

Expert Comment

ID: 36537250
My 2 suggestions (1-RAM or 2-SSD on PCIe) above doesn't require any change to the backplane or current HDD...

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
The question appears often enough, how do I transfer my data from my old server to the new server while preserving file shares, share permissions, and NTFS permisions.  Here are my tips for handling such a transfer.
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
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…

628 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