Statistics Analysis SQL Server Profiler Trace sql

--Trace file read in to table Analysis select * into Zgsjyfrom fn_trace_gettable (' E:\wxxcdbprofiler.trc ', default);--time, sqlselect top 100 SUBSTRING (textdata,1,660) as ' name ', COUNT (*) as ' quantity ', sum (duration/1000) as ' total run time MS ',       avg (duration/1000) as ' Avg. Run time MS ',       AVG (CPU) as ' average CPU time MS ', AVG       (reads) as ' average reads ', Avg       (writes) as ' average writes ' from ZGSJY GROUP by SUBSTRING (textdata,1,660) Order by sum (duration) desc

Run information for SQL from the SQL Server Profiler Tracker or the database while it is running. Then analyze the SQL time-consuming to understand the optimization point.