http://www.sqlservercentral.com/blogs/robert_davis/2011/05/25/new-whitepaper-performance-evaluation-of-hosting-tempdb-on-fusionio/

Printed 2014/12/19 04:38PM

New Whitepaper: Performance Evaluation of Hosting TempDB on FusionIO

By Robert Davis, 2011/05/25

New Whitepaper: Performance Evaluation of Hosting TempDB on FusionIO

FusionIO ioDrive Duo
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


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.