数据库查询耗时前10条

SELECT TOP 10
qs.total_elapsed_time/1000 AS total_elapsed_time_ms,
qs.execution_count,
st.text AS query_text
FROM sys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) st
ORDER BY qs.total_elapsed_time DESC;