Improving the Performance of Inserts in SQL Server

Not all All-Flash Arrays (AFA) are created equal. Just moving to an AFA doesn’t always guarantee performance improvements on the database side. That said, if your database workload is I/O bound and the storage is the bottleneck, an AFA move is likely to help drive great improvements. However, there are times when you will need to…

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…