• I tried a script from PinalDave - Look at this! Here are the top ten queries:

    MaxElapsedTimeAvgElapsedTimeLogCreatedOn

    358497204826520494/8/2014

    2855344316823810/18/2013

    2853692221863110/18/2013

    23460331852110/18/2013

    23437700562687010/18/2013

    204691007614910/18/2013

    17853331153638082/26/2014

    14070434783025910/18/2013

    8880477932390210/18/2013

    646335968180863/15/2014

    SELECT DISTINCT TOP 10

    t.TEXT QueryName,

    s.execution_count AS ExecutionCount,

    s.max_elapsed_time AS MaxElapsedTime,

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

    s.creation_time AS LogCreatedOn,

    ISNULL(s.execution_count / 1000 / NULLIF(DATEDIFF(s, s.creation_time, GETDATE()), 0), 0) AS FrequencyPerSec

    FROM sys.dm_exec_query_stats s

    CROSS APPLY sys.dm_exec_sql_text( s.sql_handle ) t

    ORDER BY s.max_elapsed_time DESC, ExecutionCount DESC

    GO