How to analyze SQL Server Profiler Tracing sql

--The trace file is read into the table to analyze  
SELECT * into Zgsjy  
from fn_trace_gettable (' E:\wxxcdbprofiler.trc ', default);  
--time, the most time-consuming SQL  
select top SUBSTRING (textdata,1,660) as ' name ',  
count (*) as ' quantity ', sum (duration/1000) as ' Total execution Time MS ', AVG (  
       duration/1000) as ' average execution time MS ',  
       AVG (CPU) as ' average CPU time MS ', AVG (  
       reads) as ' average read times ',  
       avg ( Writes as ' average number of writes ' from
zgsjy Group by substring (textdata,1,660) Order by   
sum (duration) desc

SQL Server Profiler tracks SQL execution information during a program or database run. It then analyzes the SQL time consuming, thus clarifying the optimization point.

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/SQLServer/