Automating Storage Benchmarking with DiskSpd and PowerShell

My recent post on using the new DiskSpd utility to help you benchmark your storage is a great primer on how to use DiskSpd. But… what if you want to run multiple tests? For example, what if you want to run both read and write tests with a varying degree of...

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...

Why You Should Benchmark Your Storage

You should benchmark your storage immediately. If you are a database administrator, you should benchmark it yesterday. And today. And next week. Well, that’s exaggerating things a bit… but storage performance should be at the core of your ongoing...

Webinar – Easy SQL Server Benchmarking

On Thursday, May 1st, I will be presenting a new webcast with Tegile Systems entitled “Easy SQL Server Benchmarking”. Abstract: Do you have a new piece of hardware going into service and want to see how well it performs? Or do you have a few systems and...

SQLIO Analyzer Latency Divide by Zero Issue Corrected

A special thanks goes to Daniel Angerer (t) for suggesting an improvement that corrected the divide by zero error that one of the calculations was showing on the SQLIO Analyzer Latency worksheet in the Excel file. The updated analyzer is located here. Thanks Daniel!...

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