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

Dmytro Lenchuk 21 Reputation points

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?

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. EchoLiu-MSFT 14,516 Reputation points

    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.


    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.