by David | Sep 12, 2016 | Best Practices, Performance, Technology
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...
by David | Sep 13, 2015 | Performance, Professional Development, SQL Server
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...
by David | May 8, 2015 | Cloud, Performance, Professional Development, SQL Server, Storage, Technology, Virtualization
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...
by David | Apr 1, 2015 | Performance, SQL Server, Storage, Technology
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...
by David | Feb 3, 2015 | Performance, SQL Server, Technology
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...