Monthly Archives: November 2010

PCIE SSD Update – Optimizing SQL Backup Performance

In my last blog entry (http://blogs.msdn.com/b/microsoftbob/archive/2010/11/06/the-potential-of-ssd-for-millions-of-iops-on-increasingly-larger-databases.aspx), I shared the throughput numbers backing up from 2 Fusion-IO devices to a 4-spindle 15K SAS Raid-10 device.  I also shared the numbers of backing up to NUL device, and was surprised they weren’t … Continue reading

Posted in Uncategorized | Leave a comment

The potential of SSD for millions of IOPS on increasingly larger databases

NOTE: There is an update to this article at http://blogs.msdn.com/b/microsoftbob/archive/2010/11/08/pcie-ssd-update-optimizing-sql-backup-performance.aspx regarding the throughput I was able to achieve on my own configuration with the Fusion-io backup process.  Through some parameter changes on the backup command, was able to double the … Continue reading

Posted in Uncategorized | Leave a comment

Back again, Dealing with Storage-aligned Index oddities

I’m back after being on leave for past several weeks in case you wonder why I haven’t posted.  To quote Joy Gresham from the move ShadowLands “I wasn’t dead, I was just in America (fill-in-the-blank)” This was one of my … Continue reading

Posted in Uncategorized | Leave a comment