-
Recent Posts
Recent Comments
Bob L on Moving Databases from One Inst… Bob L on History may not repeat, b… Michael Abrams on History may not repeat, b… Mark Polczynski on Moving Databases from One Inst… emilie parker on Now at 5.11 GB/s SQL backup to… Archives
- August 2016
- June 2016
- October 2015
- September 2015
- August 2015
- July 2015
- February 2015
- December 2014
- July 2014
- May 2014
- March 2014
- February 2014
- November 2013
- September 2013
- August 2013
- July 2013
- March 2013
- October 2012
- April 2012
- March 2012
- February 2012
- October 2011
- September 2011
- November 2010
- July 2010
- June 2010
- May 2010
- November 2009
- October 2009
- August 2009
- July 2009
- June 2009
- May 2009
- January 2009
- June 2008
Categories
- 2FA
- Artificial Intelligence
- Azure
- Cloud
- data security
- Fusion-io
- Hyper-v
- Machine learning
- Mulifactor Authentication
- Problem Solving
- Security
- SQL Server
- SQL Tips and Techniques
- Stock Market
- Technical Analysis
- Uncategorized
- Virtualization
- Windows Server
- Windows Server 2008 R2
- Windows Server 2012
- Windows Server 2012 R2
Meta
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