Blog Post

Azure Database Support Blog
2 MIN READ

Lesson Learned #427:BUFFER IO in Azure SQL Database (Query Data Store): An Expert's Guide

Jose_Manuel_Jurado's avatar
Jose_Manuel_Jurado
Icon for Microsoft rankMicrosoft
Sep 12, 2023
In Azure SQL Database, performance tuning often requires a deep dive into "wait stats" using tools like the Query Data Store (QDS). One prominent wait stat that might surface is BUFFER IO. Notably, w...
Updated Sep 12, 2023
Version 1.0
JayDing's avatar
JayDing
Former Employee
Oct 24, 2023

For the same query, e.g. select Id,TransactionStatusId from [dbo]. [Transaction] where IsFromPIPlatform = 1 and IsDeleted = 0 and PackageId=@PackageId

 

Depending on the query criteria, such as the packageid in this query above, does every query result in high buffer_IO or is it just a matter of chance.