SQL Server Profiler can be opened from several locations:
When a new trace is created (with the New Trace toolbar button or File → New Trace), a connection is created to a SQL Server, and the Trace Properties dialog (see Figure 38.1) displays. The Trace Properties General tab sets up the trace (name, file destination, and so on), and the Events Selection tab defines the events and data columns to be recorded, as well as the filter. If the trace is running, the properties may be viewed but not changed. You can save a trace configuration as a template to make creating new traces easier.
A Profiler trace is primarily viewed interactively (because otherwise you should be running a scripted server-side trace), but the data can also be written to a file or a SQL Server table. This is useful for further manual analysis, viewing alongside System Monitor counter data, or importing into the Database Engine Tuning Advisor.
When Profiler ...