Category Archives: Uncategorized

In Transition…

I am just getting around to moving content from my MSDN blog over to here along with a lot of other stuff. Still learning ropes as far as how to create categories as I have diverse interests. SQL Server performance, … Continue reading

Posted in Uncategorized | Leave a comment

Some thoughts on big data, predictive analytics and “A/I”

1) The problem with Artificial Intelligence is that it is artificial. What is needed is Authentic Intelligence. 2) Big Data means nothing without intelligent analytical processes. It takes the lifetime of the universe just to find the accurate solution for … Continue reading

Posted in Uncategorized | 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 Uncategorized | Leave a comment

More clarifications on 3.05 GB/s SQL backup potential for much higher throughput

A couple of clarifications – including potential for much greater backup throughput beyond 3 GB/s up to 9 GB/s for this hardware: 1) Contrary to the video, 10 GbE is not the fastest practical Ethernet for server-to-server communications. 40 GbE … Continue reading

Posted in Uncategorized | Leave a comment

A couple of corrections on video

I should have said that 40 Gbe and 100 Gbe are not widely implemented rather than not available  – they are available. But, even 100 GbE is only adequate for 12 GBPS – and with Gen 3 PCIE SSD reading … Continue reading

Posted in Uncategorized | Leave a comment

1/4 TB SQL Database backup in under 1 Minute!!! (3.05 GBPS transfer rate)

With the addition of another SATA SSD as well as another SLC Duo to serve as the target destination, the same SQL database which now has a total of 233 GB of used space was backed up in less than … Continue reading

Posted in Uncategorized | Leave a comment

Quick update on IO Accelerator (testing)

Follow-up from last post on 2.0 GBPS backup throughput – was able to update the firmware painlessly for the non-functional card from a Win 7 X64 machine so that it can now be updated on the HP Server to the … Continue reading

Posted in Uncategorized | Leave a comment

Over 2 GBps SQL Server 2012 backup on 12-core server with 7 Fusion-IO Cards!

I managed to squeeze 2 GBps (2192.207 MBps to be exact) out on 12 cores using a HP Server DL370 with 12 x 2.66 (12 MB Cache) cores, 108GB RAM, and 7 Fusion-IO Cards backing up from a database stored … Continue reading

Posted in Uncategorized | Leave a comment

2 GBps Backup Throughput with 8 Fusion-IO Cards on HP DL370 G6 12-core server

I had to turn off backup compression to do it because the 12 cores get maxed out with compression when getting above 1 GBps, but I managed to get 2GBps on my HP 12U server with 108GB of RAM with … Continue reading

Posted in Uncategorized | Leave a comment

Quick update on IO Accelerator (testing)

Follow-up from last post on 2.0 GBPS backup throughput – was able to update the firmware painlessly for the non-functional card from a Win 7 X64 machine so that it can now be updated on the HP Server to the … Continue reading

Posted in Uncategorized | Leave a comment