Home Forums SQL Server 2005 Administering Query with high lob logical reads / read-ahead reads RE: Query with high lob logical reads / read-ahead reads

  • Ok, so it looks like the size of the image being returned could be the issue.

    Looking into it, query 1 (with high lob logical reads) is actually retrieving a 6MB .mp4 file. Whereas Query 2 is getting a 1KB .xsl file..

    So the larger the physical file, the more image pages are read.

    Makes sense!