Microsoft® SQL Server 2008 R2 Unleashed

Executing Traces and Working with Trace Output

After you define the events and columns you want to capture in a trace, you can execute the Profiler trace. To do so, you click the Run button on the Trace Properties window, and the Profiler GUI starts capturing the events you have selected. The GUI contains a grid that is centrally located on the Profiler window, and newly captured events are scrolled on the screen as they are received. Figure 6.9 shows a simple example of the Profiler screen with output from an actively running trace.

Figure 6.9 The Profiler GUI with an active trace.

The Profiler GUI provides many different options for dealing ...