Post reply

sys.dm_exec_query_stats

  • November 27, 2012 at 2:57 pm

    #265260

    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

  • November 27, 2012 at 3:36 pm

    #1562870

    not this only the others

    max_logical_reads

    I couldnt figured out how to edit my post

    Im trying to get them into minutes

  • November 28, 2012 at 5:40 am

    #1563054

    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.

  • November 28, 2012 at 8:44 am

    #1563216

    Thank you

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

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