locked
IO intensive query RRS feed

  • Question

  • Hi

     
    I can able to get total_elapsed_time from DMv sys.dm_exec_query_stats

    But total_elapsed_time= execution_time + io time + sorting time + parsing time

    This is my understanding , am i right?

    And at the same time i can able to get number of IO(physical_read, logical read, logical write ) for each query from the same dynamic view.

    Actually i like to know IO time for each query.

    Any one help me to clarify and get back to me where i can get IO time for each query.

    Wednesday, December 19, 2012 1:28 PM

Answers

  • sorry, it is a wrong forum for your question

    Lev Nachmanson

    • Marked as answer by Lev Nachmanson Monday, December 24, 2012 5:34 AM
    Monday, December 24, 2012 5:34 AM