SQL Server Performance

Enhanced Read-ahead and Scan????

Discussion in 'General DBA Questions' started by tanaji_kamble, Jun 21, 2006.

  1. tanaji_kamble New Member

    what is Enhanced Read-ahead and Scan????
    can anybody suggest any article on this topic?
  2. FrankKalis Moderator

  3. ranjitjain New Member

    Even trying Google on this topic will give many good links
  4. joechang New Member

    it just means the sql server engine improved the code for read aheads and scans
    nothing you need to worry about

    also, this was intended to improve performance on good disk systems.
    if you don't have a well configured disk array, it probably wont help and may even hurt
  5. satya Moderator

    http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx a sample.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided �AS IS� with no rights for the sake of knowledge sharing.

Share This Page