Author Archives: Bob L

Relational State Sequences and SQL Server CLR Aggregate functions

My research on continuous improvement problem solving frameworks has convinced me that a problem system must possess complete data about the processes it is trying to learn from including how all the items within a solution attempt have changed. I … Continue reading

Posted in Artificial Intelligence, Machine learning, Problem Solving | Tagged | Leave a comment

Concept for a High-Performance Database (HPD)

Recently, I’ve been studying Microsoft PDW as part of an ETL integration project. This got me thinking about the distributed database computing paradigm and scaling out performance for SQL Server for OLTP purposes. PDW utilizes multiple compute nodes that are … Continue reading

Posted in Fusion-io, SQL Server | Tagged | Leave a comment

Write throttling and Fusion-io Cards

Why Fusion-IO SLC Duos may outperform MLC Duos by more than expected and some mitigations Recently I decided to revisit the issue of write throttling that occurs on Fusion-io cards under load. I found this article http://www.hookbag.ca/media/d/b5/d987/d98720b9b537819f/original.pdf that explains the … Continue reading

Posted in Fusion-io | Tagged | Leave a comment

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

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

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 Fusion-io, SQL Server | 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