Statistical Analysis of SQL statements tracked by SQL Server Profiler

-- The trace file is read INTO the table for analysis. SELECT * into zgsjyfrom fn_trace_gettable ('e: \ wxxcdbprofiler. trc ', default); -- SQLselect TOP 100 SUBSTRING (Textdata, 1,660) as 'name', count (*) as 'number' in a certain period of time ', 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 write Times' from ZGSJY group by substring (Textdata, 1,660) order by sum (duration) desc

Use SQL Server Profiler to track SQL Execution information when a program or database is running. Then analyze the SQL time consumption to clarify the optimization points.