2012年11月30日
CPU 及 IO 平均开销较大脚本
摘要： --- 平均I/O时间长的语句USE tempdbSELECT TOP 10 (total_logical_reads/execution_count) AS avg_logical_reads, (total_logical_writes/execution_count) AS avg_logical_writes, (total_physical_reads/execution_count) AS avg_phys_reads, execution_count, statement_start_offset as stmt_start_offset, SUBSTRING(... 阅读全文
posted @ 2012-11-30 18:08 _cc 阅读(1266) 评论(0) 推荐(0)