Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to:
SQL Server
Azure SQL Managed Instance
This article describes how to filter trace events based on the event start time by using SQL Server Profiler.
Filter an event based on the event start time
On the File menu, select New Trace, and then connect to an instance of SQL Server.
The Trace Properties dialog box appears.
If Start tracing immediately after making connection is selected, the Trace Properties dialog box fails to appear, and the trace begins instead. To turn off this setting, on the Tools menu, select Options, and clear the Start tracing immediately after making connection check box.
In the Trace name box, type a name for the trace.
In the Use the template name list, select a trace template.
Optionally specify a destination for the trace results.
On the Events Selection tab, select the StartTime column heading. You can also right-click the column heading, and then select Edit Column Filter to launch the Edit Filter dialog box.
Expand Greater than or Less than, and then enter a datetime value in the field that appears beneath the comparison operator.