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?