sql server 执行效率分析

SELECT TOP 50
        execution_count [执行次数] ,
        total_elapsed_time / 1000 [总耗时(ms)] ,
        ( total_elapsed_time / execution_count ) / 1000 [平均耗时(ms)] ,
        total_worker_time / 1000 [总消耗CPU 时间(ms)] ,
        qs.total_worker_time / qs.execution_count / 1000 [平均消耗CPU 时间(ms)] ,
        creation_time [首次编译时间] ,
        last_execution_time [最后一次执行时间] ,
        max_worker_time / 1000 [最大执行时间(ms)] ,
        SUBSTRING(qt.text, qs.statement_start_offset / 2 + 1,
                  ( CASE WHEN qs.statement_end_offset = -1
                         THEN DATALENGTH(qt.text)
                         ELSE qs.statement_end_offset
                    END - qs.statement_start_offset ) / 2 + 1) [执行语句] ,
        qt.text [完整语句] ,
        total_logical_reads [逻辑读总数] ,
        total_logical_reads / execution_count [每次逻辑读次数] ,
        dbname = DB_NAME(qt.dbid)
FROM    sys.dm_exec_query_stats qs WITH ( NOLOCK )
        CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) qt
WHERE   execution_count > 1
ORDER BY [执行次数] DESC