read-ahead reads in SQL Server 2005

Hi,

I would like to describe what is meant by "read-ahead reads" after having set "set statistics io on;".

Do you know where I could find information about it which is valid for SQL Server 2005? In MSDN and Google, I just found information for older versions of SQL Server.

Is this sourcehttp://www.microsoft.com/technet/prodtechnol/sql/70/reskit/part4/sqc05.mspx - which explaines quite well what I need - still valid for SQL Server 2005?

Thanks for help,

Ina

[734 byte] By [inalein] at [2008-2-15]
# 1

Read ahead reads are still available in SQL Server 2005.

http://msdn2.microsoft.com/en-us/library/ms191475.aspx

WesleyB

Visit my SQL Server weblog @ http://dis4ea.blogspot.com

WesleyB at 2007-9-8 > top of Msdn Tech,SQL Server,SQL Server Documentation...

SQL Server

Site Classified