Databases Reference
In-Depth Information
In the Trace Properties dialog box, there is a checkbox option in the General
tab with the caption Server processes trace data to specify whether trace
data should be processed on server. If not checked, trace data is processed
on client.
When trace data is processed on client, it is possible for some events to be
missed if the server load is high. If this option is checked, then trace data is
processed on the server, and all the events included in trace definition are
guaranteed to be captured without miss. However, this guarantee comes
with performance penalty because processing trace data on server has an
impact on performance of SQL Server and therefore, enabling this option is
not recommended for production servers. Also, running SQL Server Profiler on
production server itself should be avoided.
6.
Click on the Events Selection tab. On this screen, the events that are predefined for
Standard (default) trace template are selected and shown in grid. Enable the Show
all events checkbox to show all events. Navigate through the event list until you
find the Stored Procedures event category. Expand Stored Procedures event
category if it is collapsed. Uncheck the checkbox for RPC:Completed event and
enable the checkbox for SP:Completed event. Disable the Show all events
checkbox to show only the selected events. The screen should now look similar
to the following screenshot:
Search WWH ::
Custom Search