統計分析SQL Server Profiler 跟蹤的SQL

標籤：des   blog   io   檔案   資料   ar   2014   art   

--追蹤檔案讀入到表中分析SELECT * INTO ZGSJYFROM fn_trace_gettable(‘E:\wxxcdbprofiler.trc‘, default);--某時間內，最耗時SQLselect TOP 100 SUBSTRING(Textdata,1,660) as ‘名稱‘,count(*) as ‘數量‘, sum(duration/1000) as ‘總已耗用時間ms‘,       avg(duration/1000) as ‘平均已耗用時間ms‘,       avg(cpu) as ‘平均CPU時間ms‘,       avg(reads) as ‘平均讀次數‘,       avg(writes) as ‘平均寫次數‘from ZGSJY group by substring(Textdata,1,660) order by sum(duration) desc

通過SQL Server Profiler 跟蹤程式或者資料庫運行過程中SQL的運行資訊。然後分析sql耗時，從而明白最佳化點。