An administrative tool in Microsoft SQL Server 7. Called SQL Trace in version 6 of SQL Server, SQL Server Profiler can be used to track activity on a server running SQL Server. SQL Server Profiler captures information in the form of engine events that are saved in a trace file. You can then analyze the trace file or use it to replay a series of steps that led to a problem in order to troubleshoot the exact cause of the problem. You can save the trace data to a file or to a database table for further analysis.
You typically use SQL Server Profiler to do the following: