SELECT TOP 10

    t.text AS QueryText,

    s.execution_count AS ExecutionCount,

    s.max_elapsed_time AS MaxElapsedTime,

    ISNULL(s.total_elapsed_time / s.execution_count, 0) AS AvgElapsedTime,

    s.creation_time AS LogCreatedOn

FROM

    sys.dm_exec_query_stats AS s

CROSS APPLY

    sys.dm_exec_sql_text(s.sql_handle) AS t

ORDER BY

    s.max_elapsed_time DESC;