标签:DMV

SQL Server DMV查询SELECT所消耗的时间

Nishizhen | 数据库 | 2011-12-21
SQL Server DMV查询SELECT所消耗的时间
SELECT TOP 20 CAST(qs.total_elapsed_time / 1000000.0 AS DECIMAL(28, 2)) AS [Total Elapsed Duration (s)], qs.execution_count, 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... [阅读全文]
Ɣ回顶部