Over the last two years, I have stood up several proof-of-concept (POC) database server systems with consumer grade SSD storage at cost $2-4K per TB. Of course production servers are on enterprise class SSD, Fusion-IO and others, typically $25K+ per TB. (There are some special situations where it is viable to deploy a pair ...

Brent Ozar (blog | twitter) recently made some comments about the FusionIO SSD drives.  Basically, he was able to break three drives in a row - simply by doing load testing against them (using SQLIO).  The symptom is simple: the drives go offline and disappear from the O/S, and need to be physically pulled from the machines.  Kind ...

A recently published TPC-H benchmark result, along with previously published results provide some insight into to the relative impact of SSD to disk drives, and SSD versus system memory. The TPC-H configurations are shown below. All results are at SF 100. The first two are on Windows Server 2003 sp1, and SQL Server 2005 sp1 and sp2 ...

Dell recently published a TPC-H report for the PowerEdge T610, 2 x Xeon 5570, with 4 FusionIO 80GB SSD storage devices at 100GB scale factor. So why have we not seen TPC-C or TPC-E OLTP benchmark results published?   Now it is much more feasible to run the TPC-H data warehouse benchmark on SSD because the Scale Factor 100 size is ...