Friday, March 30, 2012

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 source http://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

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

No comments:

Post a Comment