gistfile1.txt

--DBCC FREEPROCCACHE

--PERFORMANCE DE TODAS AS CONSULTAS EXECUTADAS
select
    object_schema_name(qt.objectid, qt.dbid) + '.' + object_name(qt.objectid, qt.dbid) as db_name,
    substring(
        qt.text,
        qs.statement_start_offset/2 + 1,
        (
            case 
                when qs.statement_end_offset = -1
                then len(convert(nvarchar(max), qt.text)) * 2
                else qs.statement_end_offset 
            end - qs.statement_start_offset
        )/2 + 1
    ) as query_text,
    convert(varchar(8), qs.creation_time, 108) creation_time,
    convert(varchar(8), qs.last_execution_time, 108) last_execution_time,
    qs.total_elapsed_time/1000000.0 as total_elapsed_time,
    qs.execution_count,
    qs.total_elapsed_time/qs.execution_count/1000000.0 as avg_duration
from sys.dm_exec_query_stats as qs
cross apply sys.dm_exec_sql_text(qs.sql_handle) as qt
where 1=1
order by total_elapsed_time desc