what is logical reads in sql server? how to reduce no of logical?
From Microsoft SQL Server Documentation (Pages and Extents Architecture -> Reading Pages) has a good definition: The I/O from an instance of the SQL Server Database Engine includes logical and physical reads. A logical read occurs every time the Database Engine requests a page from the buffer cache. If the page is not currently in … Read more