How to Use DiskSpd to Benchmark Your Storage for SQL Server

If you’ve been working with SQL Server for a while,  chances are that you have worked with the SQLIO utility in the past to benchmark storage for your SQL Server implementation. As many are already aware, the SQLIO utility has been retired and no longer distributed or maintained. Microsoft has introduced and recommends the use of a…

Oracle Performance – Full Table Scan

In previous posts, we have discussed different Oracle wait events and the performance improvements that will be seen with the Kaminario K2 system. In this post, I would like to discuss how such an improvement affects the execution of a query and ultimately the end user queries. Let’s look at a simple select count from…