日韩精品电影一区亚洲|综合狠狠亚洲婷婷97|久久久久国产精品熟女影|色婷婷精品综合久久狠狠|中文字幕无码人妻免费视频|韩国精品无码一区二区在线|国产亚洲精品美女久久久久|国产亚洲精久久久久久无码色欲

--(SELECT SUBSTRING(s2.text, statement_start_offset / 2, ((CASE WHEN statement_end_offset = -1 THEN (LEN(CONVERT(NVARCHAR(MAX), s2.text)) * 2) ELSE statement_end_offset END) - statement_start_offset) / 2) ) AS query_text

FROM

(SELECT TOP 50

SUM(qs.total_worker_time) AS total_cpu_time,

SUM(total_physical_reads) AS [total_physical_Reads],

SUM(qs.execution_count) AS total_execution_count,

COUNT(*) AS number_of_statements,

qs.sql_handle --,

--MIN(statement_start_offset) AS statement_start_offset,

--MAX(statement_end_offset) AS statement_end_offset

FROM

sys.dm_exec_query_stats AS qs

GROUP BY qs.sql_handle

ORDER BY SUM(qs.total_physical_Reads) DESC) AS stats

CROSS APPLY sys.dm_exec_sql_text(stats.sql_handle) AS s2