Trace is a session during which the events are captured and event data is collected. SQL Server supports a few formats for saving this collected trace data, which is known as a workload. We can save trace data (a workload) in one of the following formats:
We are going to use trace file
.trc for this recipe. For detailed information regarding trace, workload, and different events of trace in profiler, refer Creating a trace or workload recipe in Chapter 1.
In this recipe, we will create a trace with SQL Server Profiler; execute some queries that will be captured in running ...