X hits on this document

130 views

0 shares

0 downloads

0 comments

7 / 48

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).

641

Document info
Document views130
Page views130
Page last viewedSun Dec 11 02:43:42 UTC 2016
Pages48
Paragraphs987
Words15822

Comments