SQL Profiler captures and displays a specific SQL workload for analysis in a SQL trace. You can start and review captured SQL traces immediately, or save captured traces for review at a later time.Capturing a new SQL trace is very simple. To open SQL Profiler, select the SQL Profiler menu option from the Management menu. Upon startup, SQL Profiler will present you with a dialog asking if you would like to start a new trace, or open an existing trace.If you choose to start a new trace (capturing SQL statements executed against the currently selected server) SQL Profiler will open the Create New SQL Trace dialog, as shown in Figure 11.1.Use fields on the dialog to selectively filter the captured SQL statements by user account and by database. You may choose to limit your trace, or to capture every SQL statement sent by all users against all databases.You can also name your trace for future reference and set a maximum file size for the resulting trace file. Lastly, you can choose to begin capturing SQL immediately in an ad-hoc fashion (if you choose this option, you must manually stop the trace), or you can schedule the trace to run at a later time.Scheduling a trace is particularly beneficial for capturing workloads during off hours. For example, you may want to capture the SQL statements that are executed against a server from 2 - 4 am. You can configure your trace to run during that timeframe and then examine the output at your leisure when you arrive at work in the morning.When you are satisfied with all your selections, click the OK button to start the trace.