Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  SQL Server Administration (2008)  I/O type

Author  Topic  adiso75 Starting Member 1 Post Posted - 2011-01-03 : 10:41:54 Hi All, Is there any way to distinguish between I/O wait type for a given session? for example, I'd like to know if the session is waiting for random read or sequential read? I can see I/O wait when the session is waiting for I/O event such as "PAGEIOLATCH_EX" but I don't know if it is doing sequential or random read. Thx Adi