Log I/O and Data I/O by SQL Query

Question

Hey, which of the columns in table SYS.Dm_Exec_Query_Stats equals to Data I/O and Log I/O in Query Performance Insight in Azure SQL Database?

Answer 1

Hi @Dmytro Lenchuk ,

Sorry, I am not very familiar with Azure SQL Database. I did a simple search for Query Performance Insight, but I am not sure which column you need. The following link has the function introduction of each column in the SYS.Dm_Exec_Query_Stats table. You can check which column is what you need:
sys.dm_exec_query_stats (Transact-SQL)

If you have any question, please feel free to let me know.

Regards
Echo

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.