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?
    tanaji_kamble, Jun 21, 2006
    #2

  2. FrankKalis Moderator

    FrankKalis, Jun 21, 2006
    #2

  3. ranjitjain New Member

    Even trying Google on this topic will give many good links
    ranjitjain, Jun 21, 2006
    #2

  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
    joechang, Jun 21, 2006
    #2

  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.
    satya, Jun 21, 2006
    #2

Share This Page