Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am looking at building a server for a friends business. This would probably be a SuperMicro job to come in on a small budget, 9 series with Sandy Bridge Dual Socket 2011 26xx processors.

I'm looking to maximize price/performance. Who isn't? Right? Well, I've been looking at the cost of 15k SAS 6Gb drives vs SSD's, and the price is fairly comparable. The advantage being that I wouldn't need a SAS controller and could get by with a good SATA 6Gb controller (half the cost). Also, SSD's give off considerably less heat.

However, I realized that I'm not sure what the disk usage profile of exchange and MS CRM (which are the two major apps that will be running on the server). How much do either Exchange or CRM (ie sql server) write and rewrite to the disk for light usage scenarios?

My concern is that either Exchange or the CRM's SQL Server will make excessive writes, and wear down the SSD's in an overly fast timeframe.

Is anyone aware of the Exchange and Sql write characteristics? Will using SATA 6Gb/s SSD's with 95,000 IOPS compare favorably to similar 15k SAS? SAS of course has advantages of SATA, but would SATA SSD's cancel out those benefits?

share|improve this question

1 Answer 1

up vote 1 down vote accepted

I'd stick with a real SAS RAID controller since they can also address SATA drives (including SATA SSD's).

My experience with Exchange 2010 is that it seems to try to do everything to minimize disk I/O. RAM tends to be more important because of caching and what seem to be coalesced writes. I'm only using Exchange in 150-user and less scenarios, though. I'm not sure on the CRM side... Possibly a 50/50 mix of small random and sequential I/O.

Small budget doesn't necessarily mean you need to compromise. Buying a SATA-only controller is a bad compromise. The value in SSD's here would be that you'd need fewer of them to achieve the I/O that a larger number of rotating hard disks could achieve. That's assuming you've figured out what your storage capacity needs are. Please RAID the SSD's (4 or more drives) and don't worry about wearing them out at this point...

share|improve this answer
    
Valid point about the SAS RAID controller. My thinking though is with the much higher IOPs in an SSD that cacheing on the RAID was less important, so I could get by with a cheaper controller. Yes, I was planning to RAID the SSD's. I'm basically thinking 3 256GB SSD's in a RAID 5, vs 3 300GB 15k SAS drives in RAID 5. Does the SAS command set and dual porting give SAS an edge over the SSD's or does the higher thruput of the SSD's cancel out the SAS advantage over SATA? Endurance wise, I don't want to have to replace the SSD's in 6 months or a year. –  Erik Funkenbusch Nov 1 '12 at 7:49
    
What's your budget? –  ewwhite Nov 1 '12 at 8:00
    
I'm hoping to spend less than $1000 on the storage subsystem (controller + drives), and need 5-600GB of storage with redundancy and striping. Not sure if Raid 10 would be any advantage with SSD's over Raid 5 –  Erik Funkenbusch Nov 1 '12 at 8:09
    
@MystereMan Total budget. I buy HP servers, for instance. I never have to buy separate RAID controllers. –  ewwhite Nov 1 '12 at 8:12
1  
Exchange 2010 is optimized for low IOPS, by caching a lot of stuff to RAM and read/write sequentially when it can. In other words, it works just great on regular 7200RPM's in RAID5 (careful!) or RAID6. –  pauska Nov 1 '12 at 13:04

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.