Database Reference
In-Depth Information
Figure 18-15.
Selecting a template for the new trace with SQL Server Profiler
In our example, we have typed
ReportQueryPerformance
in the “Trace name” textbox. We also selected
Tuning from the “Use the template” dropdown box. Once you have made the selections, click Run to start the trace.
Running a Trace
As a trace starts, you will see a new dialog window appear that displays the activity occurring on the connected
database engine from the various clients. For example, if we were to create a new SSRS report and preview the
results, the
SELECT
statement used in the SSRS report would run and be captured by the SQL trace, as shown in
Figure
18-16
. Information about how long it took to resolve the query is shown in the Duration column. In this
example, the group was resolved in 20 milliseconds, which of course is not much time, but for larger Datasets and
more complex queries, you can expect the number to increase.