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 the drives. In the latest test, I got up to 5.11 GB/s (5228.521 MB/sec) doing…

0

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 network cards and switches are available and affordable. It is feasible to achieve 5GB/s using…

0

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 at 3.0 GBps +, that will easily be overrun by newer servers that can utilize…

0

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 1 minute using the same server referenced in my prior 2.0 GBPS backup post (http://blogs.msdn.com/b/microsoftbob/archive/2012/10/18/2gbps-backup-on-12-core-server-with-7-fusion-io-cards.aspx)….

0

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 latest HP-branded IO Accelerator driver. To my pleasant surprise, the last generic driver version (2.3.10)…

0

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 on 5 cards to backup files spread across 2 other cards, 1 Intel SSD, and…

0

Software Quality – 4 Key facets (From Linked-in)

I have become active in the Linked-in Community, especially regarding predictive analytics, as there are many very good discussion groups. So, to save effort and still get a couple of hours of sleep, a lot of my posting here will come from there. The below is not a predictive analytics post, but an answer to question…

0

Memory via PCIE-SSD as the authoritative data source

i’ve blogged a few times about Fusion-IO devices and my experiences with SSD. I’ve been thinking about the implications of large in-memory databases that retain persistence and transactional capabilities. Turns out the game may be changing long-term to an in-memory database model forscalability. I.e. Fusion-IO demonstrated technology that extends memory to Fusion-IO devices and supports up to…

0

Boolean KMAP reduction code released after 23 years!

Yes, I know its been a while since I have posted anything and way past due to post my update on my fusion-io card testing (I now have 6 memory devices in my R710 – 2 cards are duo). I will hopefully get to that in the next couple of weeks as I am using all…

0