Tag Archives: SQL Database peformance

Home-grown PCIE SSD VM vs. Azure (Update 12/7)

More testing today with larger database, multiplied the number of rows by 10x up to 1 billion rows in the test dataset.  The latest results indicate I/O about 3 times slower on an Azure D13 server using similar CPU/Ram specs … Continue reading

Posted in Azure, Cloud, SQL Server | Tagged , , | Leave a comment

Now at 5.11 GB/s SQL backup to Null/3.12 GB/s local backup with I/O Accelerators

This will be my last update for a while, but I did some more shuffling of the database files among the various PCIE SSD logical drives (HP I/O Accelerators which are HP-OEM Fusion-Io cards). See earlier post for info about … Continue reading

Posted in Fusion-io, SQL Server | Tagged | 1 Comment