Recently when i was working on tuning of stored procedures and i experienced with one performance issue, that was high Logical Reads.
"Number of pages read from the data cache" - It occurs every time when the database engine request a page from buffer cache, otherwise physical reads occurs if currently page is not available in buffer cache.
Tags: sql, sql server, ms sql, ms sql server, #SQL Server, #sql, database, sql server general, SQL Scripts, Index, Logical reads, Reads
Nice blog!!! refreshed today morning with a cocept.
It would be great if you could explain how adding index would reduce the number of logical reads.
Without index it pulling large number of records and scan the whole table pages to read qualified records, so creating an index will help to reduce number of records set and seek only qualified records from page. It should have proper indexing.
Simply Superb Article.Past few days only am going through your blog nice posts.