CHAPTER 28 ■ PERFORMANCE TUNING
Figure 28-2. The Trace Properties dialog box
4. Next, click the Events Selection tab in the Trace Properties dialog box (see Figure 28-3). It is here that the traced events from the pre-canned TSQL_Duration template are loaded. Cur- rently two different events will be monitored, RPC:Completed and SQL:BatchCompleted. This means that SQL Server Profiler will return a row for every remote procedure call or Transact- SQL statement that has completed on the SQL Server instance. This window also shows the columns which will be returned in the trace data, in this case including the Duration (duration of the completed query), TextData (capturing the actual Transact-SQL), SPID (the server process id of the caller), and BinaryData (returns different data depending on the event).