Share via

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,665 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. EchoLiu-MSFT 14,591 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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.