by David | May 5, 2015 | Performance, SQL Server, Storage, Technology
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...
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...
by David | Dec 15, 2014 | SQL Server, Storage, Technology
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...
by David | Apr 21, 2014 | Business, Events, Performance, Professional Development, SQL Server, Storage
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...
by David | Nov 26, 2012 | Storage
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!...