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…

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 article on active-active vs active-passive 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…

“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…

“DB File Scattered Read” Wait Event

In a previous post, “db file sequential read” wait event, I have explained the db file sequential read wait which is the most common wait event in Oracle that is associated with I/O Wait). In this post I will describe the second most common event that I see when system suffer from I/O waits: db file…