How to set a StartTime filter for a trace (SQL Profiler)

How to set a StartTime filter for a trace (SQL Profiler)

To set a StartTime 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 which you want to connect 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 StartTime.
   
   
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