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

Dmytro Lenchuk 21 Reputation points
2021-09-22T12:03:10.45+00:00

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
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,552 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. EchoLiu-MSFT 14,571 Reputation points
    2021-09-23T01:39:09.553+00:00

    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.