Mastering SQL Trace Using Profiler - Microsoft SQL Server 2012 Performance Tuning - page 16

Now, we will create a trace and capture only events that occur for AdventureWorks2012
database from James' session only. To do this, follow these steps:

1. Start SQL Server Profiler.
2. Select New Trace… from the File menu. In the Connect to Server dialog box, provide
connection details of SQL Server hosting the AdventureWorks2012 database and
click on Connect.

3. In the General tab of Trace Properties, enter FilteringEvents as the Trace name

and select Blank template for the Use the template: drop-down menu as shown
in following:

4. In Events Selection tab, check the checkbox for event class SQL:BatchCompleted
under the TSQL event category as shown in following screenshot: