A colleague I work with on the PQO* Operations SQL V-Team, Jonathan Foster, has authored and published a whitepaper on using FusionIO SSD drives for tempDB performance in SQL Server. I served as technical reviewer and Jimmy May (blog|@aspiringgeek) from Microsoft's SQL Cat Team (blog|@SQLCat) and Ken Hughes from FusionIO provided highly beneficial technical advice. Andre Ciabattari and John Yi from the PQO Operations Infrastructure/Lab team provided technical excellence with installing and configuring the FusionIO drives in the test server.
Title: Performance Evaluation of Hosting TempDB on FusionIO
Writer: Jonathan Foster
Technical Reviewer: Robert L. Davis
Special Acknowledgement: Jimmy May, Andre Ciabattari, John Yi, and Ken Hughes.
Published: April 2011
Applies to: SQL Server 2008 R2 – Hosting TempDB on FusionIO ioDuo 1280GB MLC
Summary: This paper compares the TempDB performance between direct-attached physical disks and the FusionIO MLC DIMMS.
* PQO = Product Quality & Online, a division of Microsoft's CSS (Customer Service & Support) organization.
To comment on this post, please visit the parent site at www.sqlsoldier.com/wp/sqlserver/performanceevaluationofhostingtempdbonfusionio