How to set an EndTime filter for a trace (SQL Profiler)

How to set an EndTime filter for a trace (SQL Profiler)

To set an EndTime filter for a trace

1. On the File menu, point to New, and then click Trace.
   
   
2. In the Connect to SQL Server dialog box, select the server to connect to and a connection method.
   
   
3. In the Trace Properties dialog box, do the following:
   • In the Trace name box, type a name for the trace.
     
     
   • In the Template name list, select a trace template.
     
     
   • Optionally, specify a save destination for the trace results.
4. Click the Filters tab, and then in the Trace event criteria box, expand EndTime.
   
   
5. Expand Greater or Less than, and then enter a time value in the field that appears beneath the criterion.

See Also

Monitoring with SQL Profiler