sys.dm_exec_query_stats

  • Is there a way to get sys.dm_exec_query_stats

    These below in minutes or more readable time?

    ,max_logical_reads

    ,total_worker_time/execution_count

    ,total_elapsed_time/execution_count

    Thanks in advance

  • not this only the others

    max_logical_reads

    I couldnt figured out how to edit my post

    Im trying to get them into minutes

  • You can simply divide the values in the select list. In this example I return the time-values in seconds.

    declare

    @DividerMicroSecondsToMinutes int = 60000000

    select total_elapsed_time / @DividerMicroSecondsToMinutes

    from sys.dm_exec_query_stats

    Same thing for the reads. Just choose a divider and use it in the select list.

  • Thank you

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply