benchmark

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!


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