Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

what is read ahead read/ Expand / Collapse
Author
Message
Posted Tuesday, April 14, 2009 5:26 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, June 12, 2009 4:15 AM
Points: 21, Visits: 31
hi forum

what is read ahead read, where and when the sql server recognises these reads and how ?

Manz
Post #696435
Posted Tuesday, April 14, 2009 6:14 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, August 15, 2014 5:29 AM
Points: 431, Visits: 978
Read-ahead schemes enable applications to minimize the number of database round trips by retrieving a working set prior to use.

=============================================================
Atif Shehzad
DBA
Zin Technologies
Post #696461
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse