Blog Post

Azure Database Support Blog
3 MIN READ

Lesson Learned #451:Deep Dive into Physical and Logical Reads in Azure SQL Database: Hands-On-Lab

Jose_Manuel_Jurado's avatar
Jose_Manuel_Jurado
Icon for Microsoft rankMicrosoft
Nov 10, 2023
This week, I addressed a customer's request to understand the differences between Physical and Logical Reads and how they affect performance. Here’s an explanation and an example to help clarify thes...
Updated Nov 10, 2023
Version 1.0
azure sql database
Logical Read
performance
Physical Reads
Rollback250's avatar
Rollback250
Copper Contributor
Feb 28, 2024

 

Hi!

In part 1 you said that minimizing logical reads is critical to query performance. The article below shows that a 96% reduction in logical reads results in a saving of only 200ms. Please see the link below and add your comments about it there:

https://www.mssqltips.com/sqlservertip/7911/sql-server-clustered-index-seek-may-not-yield-the-highest-performance/