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…

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

“DB File Sequential Read” Wait Event

In a previous post, I have discussed steps and methods to calculate I/O wait from an Oracle AWR report. The key and sometimes challenging task is to identify a wait event which is related to the storage. While many waits may be caused by I/O related performance issues, the following waits are the main ones…

Measuring I/O Wait – Part 2: SQL Server

In the post “Measuring I/O Wait – Part 1: Oracle”, I discussed how to measure and calculate I/O waits in Oracle. In this post, I will demonstrate how to perform the same calculation with SQL Server.