New Whitepaper: Performance Evaluation of Hosting TempDB on FusionIO
Image compliments of FusionIO
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.
Twitter
LinkedIn
TLF
RSS
WritersCafe
SQLPASS
Facebook
Congrats on the great work. Robert! This white paper fills a much-needed hole in the body of IP re: SQL Server performance & Fusion-io. The combination is no less than game-changing.
Thanks Jimmy!! And thanks for your assistance in it. We couldn’t have gotten it done without you!!
Pingback: Something for the Weekend – SQL Server Links 27/05/11 | John Sansom - SQL Server DBA in the UK
Congratulations on the white paper Robert. Its good to see you tech review this white paper.
Regards
Meher
Thanks Meher!!