Load Testing Results Might Not Be What You Think

Bottlenecks in your testing tools, infrastructure, or methodology might just hurt your load test results, and the results can skew your metrics. For example… A few weeks ago we were running an iperf load test to see what improvements (if any) could be made to...

HammerDB Performance Collection with SQL Server – Updated

A while back, my friend Mike Fal ( b | t ) released a PowerShell script that can sample the counter inside SQL Server that one of my favorite database benchmarking utilities, HammerDB, uses to produce the transactions per minute counter value that the benchmarking...

Bringing Together Databases, Virtualization and Storage

A few weeks ago Bala Narasimhan from PernixData and I recorded a short conversation where we discussed the tips and tricks that both DBAs and Infrastructure Administrators need to maximize the performance of their systems without significant re-architecting of their...

Storage Benchmarking with DiskSpd

As I mentioned in my storage benchmarking post, storage performance is one of the critical infrastructure components underneath a mission-critical SQL Server. My defacto storage benchmarking utility has been recently updated. Last October, Microsoft released a great...

Storage Benchmarking with SQLIO Batch

The goal of the storage performance analysis is to identify the performance characteristics of a target storage device. To determine the baseline of each system’s configuration, the free disk benchmarking utility from Microsoft called SQLIO can be used to determine...

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close