摘要:
[转]找出性能差的语句1 找出效率低的语句SELECTTOP10 qs.total_worker_time,qs.total_logical_reads,qs.last_logical_writes,qs.plan_handle, qs.execution_count, (SELECTSUBSTRING(text,qs.statement_start_offset/2+1, (CASEWHENqs.statement_end_offset=-1 THENLEN(CONVERT(nvarchar(max),text))*2 ELSEqs.statement_end_offset END-qs.s 阅读全文
posted @ 2013-11-11 17:33
wavegui
阅读(282)
评论(0)
推荐(0)
浙公网安备 33010602011771号