sys.dm_exec_query

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » T-SQL (SS2K8) » sys.dm_exec_query_stats

sys.dm_exec_query_stats

Rate Topic

Display Mode

Topic Options

Author

Message

D-SQL

Posted Tuesday, November 27, 2012 2:57 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 16, 2013 5:44 PM
Points: 69, Visits: 428

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

Post #1389427

D-SQL

Posted Tuesday, November 27, 2012 3:36 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 16, 2013 5:44 PM
Points: 69, Visits: 428

not this only the others
max_logical_reads

I couldnt figured out how to edit my post

Im trying to get them into minutes

Post #1389437

WolfgangE

Posted Wednesday, November 28, 2012 5:40 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:56 AM
Points: 74, Visits: 419

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.

Post #1389671

D-SQL

Posted Wednesday, November 28, 2012 8:44 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 16, 2013 5:44 PM
Points: 69, Visits: 428

Thank you

Post #1389855

« Prev Topic | Next Topic »

Permissions