Reference Architecture for Running SQL Server on ESXi

  As a leader in the solid-state array market, one of Kaminario’s goals is to ensure easy and time-efficient adoption of our technology.  As a result, we’ve identified the need to provide best practices for running various workloads on the Kaminario K2 array. Our Solutions Engineering team is working on compiling step-by-step guides on the most technically…

Managing Oracle Backups with K2 VisionOS Snapshots

This is a guest blog by Gur Rosen, Solutions Engineer in the Kaminario Engineering team. Gur documents his recent experience running a test for a customer to validate Oracle’s backup and restore functionality with Kaminario K2 VisionOS Snapshots. — A customer recently asked us if we support Oracle’s Backup and Restore options for Creating Backups…

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…