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…

Putting an End to the Active-Active vs. Active-Passive Debate

The following is a re-post from the FlashDBA website published here with permission from Mr. FlashDBA himself, Chris Buckel. Amongst some other great material, it references “Groats” – we had to look that one up! — I want you to imagine that you are about to run a race. You have your trainers on, your pre-race warm…

Active-Active vs. Active-Passive Storage Controllers: Why Should You Even Care?

If you don’t have a great understanding of storage controller design, you are in excellent company. In fact, many IT veterans have only a basic understanding of the different controller architectures out there. And most everyone’s eyes start to glaze over when the terms active-active and active-passive controllers start getting thrown around. And if you made…

Direct Path Read Temp and Direct Path Write Temp, Revisited

A few years ago, we set out to define everything you need to know about Oracle I/O waits events. This was part of a series that dealt with Oracle I/O Wait events – “ ‘db file sequential read’ wait event,” “db file scattered read,” “Direct Path Read,” and “Direct path read temp and direct path…

“Log File Sync” Wait Event

In the series of Oracle storage wait events I have covered so far, five different events are related to the storage: “db File Sequential Read”, “db File Scattered Read” wait events, “Direct Path Read”, “Direct Path Read/Write temp” and “Free Buffer Wait”. In this post, I will describe the log file sync wait event, which…