To run Event Profiler, users must be granted the following permissions:
On the Start page, click Profile Server Events. The Profile Server Events wizard appears.
Specify the connection.
Optionally, select a profiling template, modify the trace file settings and the data storage settings. Click Next.
If no template is selected the Standard template will be used by default.
On the Events to Capture page, select the events you want to capture. Click Next.
By default, the wizard shows the events, that are included into the selected template. To add additional events, select the Show all check-mark.
Optionally, on the Actions page, select the actions you want to capture in the current events session. Click Next.
Optionally, on the Event Filters page, specify filter options to limit the tracing data.
Click Execute. The Trace will start and the Server Event Profiler Document opens.