New eBook with Pure Storage - Overcoming SQL Server Storage Challenges

Heraflux is proud to announce a new ebook as part of our joint partnership with Pure Storage! This ebook, entitled Overcoming SQL Server Storage Challenges, discusses the current state of infrastructure technologies and how it interacts and impacts the performance of Microsoft’s flagship database engine SQL Server. Arguably, storage has historically been the slowest part of the infrastructure stack underneath the database, so much so that the core database engine makes some assumptions that it will always be the case. Modern CPUs, memory, and even the network are much less a bottleneck than administrators commonly realize. Even modern SQL Server in-memory features, such as in-memory OLTP and columnstore indexes, are heavily dependent on the performance of the storage underneath them.

Learn more about how SQL Server and the enterprise storage your data rests on complement and contradict each other in this exciting new ebook authored for Pure Storage! Download this exciting PDF today!


Pure Accelerate 2017

Heraflux is proud to be speaking at this year’s Pure Storage Accelerate conference, to be held June 12-14 at Pier 70 in San Francisco. David Klee will be speaking with Argenis Fernandez on a number of key topics, such as SQL Server performance on all-flash.


PASS Summit 2016

PASS_2016_WebsiteIn addition to the all-day preconference training session prior to the main event, Heraflux is proud to present two general sessions in this year’s PASS Summit.

The first general session is a rapid-fire deep-dive on the virtualization topic for those that cannot make the precon session, entitled “Virtual SQL Servers. Actual Performance.

Virtualizing your business-critical SQL Servers should not imply that they will run slower than if they were physical. When properly architected and managed, virtual SQL Servers should be equally as fast as their physical counterparts, if not faster. However, if not properly constructed, silent and seemingly random performance killers can strike and significantly hurt your database performance.

This session is packed with many tips and tricks gained from years of experience for getting the most performance from your virtual SQL Servers. The major roadblocks to performance will be discussed and the knowledge gained will help you work with your infrastructure engineers so you can optimize the system stack for performance. Tools, techniques, and processes will be demonstrated to help you measure and validate the system performance of the key components underneath your data.

The second general session is a deep-dive on storage performance with Argenis Fernandez and Lou Lydiksen of Pure Storage entitled “Storage Testing for Database Professionals“.

More and more Database Professionals are tasked with performing testing and validation of storage devices and surrounding infrastructure to be used for database workloads they support. In this session we will give you all the tools you need to be effective at performing such testing and validation. We will argue pros and cons of synthetic testing. Tools like DiskSpd and VDBench will be discussed, along with SQL Server-specific tools to test real workloads like Distributed Replay and RML utilities. Links to tools and pre-packaged scripts will be provided.

Register for this amazing event today!


Speaking at PASS Summit 2016

Heraflux is honored to be speaking at the PASS Global Summit again this year in Seattle during the week of October 24th. David Klee is presenting two sessions on our favorite topic – the convergence of infrastructure and data.

Read more


Free eBook - Modern Storage Strategies for SQL Server

Heraflux is pleased to announce the general availability of a new free ebook collaboration with James Green from ActualTech Media called “Modern Storage Strategies for SQL Server“.  Storage is so vitally important to SQL Server performance, but the intricacies of one side’s administrators are rarely known by the other.

Read more


Announcing DiskSpd Batch

Heraflux has released a free PowerShell-based testing script to help you see how well your storage performs under varying types and intensity of workloads.

Microsoft’s SQLIO disk benchmarking utility had served the SQL Server community extremely well for many years. However, Microsoft has recently released a new storage benchmarking utility, called DiskSpd, as an open-sourced project for the community. This utility provides a more granular storage testing methodology, along with sub-microsecond latency values that are very important with today’s all-flash and hybrid storage devices. DiskSpd is now Heraflux’s preferred method for stress-testing storage devices.

Read more