Profiling server events

Permissions Required to Run Event Profiler

To run Event Profiler, users must be granted the following permissions:

  • ALTER TRACE
  • ALTER ANY EVENT SESSION
  • CONNECT SQL
  • VIEW SERVER STATE TO login_name

To grant the permissions:

  1. Open **Security Manager, expand the Logins node, and then select a required user login in the tree.
  2. Switch to the Server Permissions tab of the Logins Editor.
  3. Select the Granted check-box next to the permissions.

For more information, refer to the Manipulating User Logins topic.

To create a new trace:

  1. On the Start page, navigate to Administration, and then click Profile Server Events. The Profile Server Events wizard appears.

  2. Specify the connection.

  3. Optionally, select a profiling template, modify the trace file settings and the data storage settings. Click Next.

    Profile Server Events

    **Note**<br> If no template is selected the Standard template will be used by default.
    
  4. On the Events to Capture page, select the events you want to capture. Click Next.

    **Note**<br> By default, the wizard shows the events, that are included into the selected template. To add additional events, select the Show all check-mark.
    
  5. Optionally, on the Actions page, select the actions you want to capture in the current events session. Click Next.

  6. Optionally, on the Event Filters page, specify filter options to limit the tracing data.

  7. Click Execute. The Trace will start and the Server Event Profiler Document opens.

    Server Event Profiler