THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Performance » SSD   (RSS)
  • Consumer SSDs with SQL Server

    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 ...
    Posted to Joe Chang (Weblog) by jchang on September 16, 2011
  • Your laptop may be ready for SSDs, but are your SQL Servers?

    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 ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 1, 2010
  • Solid State Drive versus Memory, TPC-H Nehalem

    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 ...
    Posted to Joe Chang (Weblog) by jchang on August 12, 2009
  • Why have we not seen TPC-C and TPC-E benchmarks using SSD storage?

    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 ...
    Posted to Joe Chang (Weblog) by jchang on July 1, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement