Database Reference
In-Depth Information
Setting Up the SQL trace
To get things going, we need to create a trace within sQl Profiler.
1.
start sQl Profiler from the Windows start menu. To access sQl Profiler, use the
Windows menu item: start ➤ Ms sQl server 2012 ➤ Performance Tools ➤ sQl
server Profiler. Right-click this menu item to see an additional context menu, and
then click the Run as Administrator menu item. if the uAC message box appears
asking, “do you want the following program to make changes to this computer?”
click Yes (or Continue depending upon your operating system) to accept this request.
2.
3.
When the Trace Properties dialog window appears, fill in the “Trace name” textbox
4.
in the Trace Properties dialog window, select Tuning in the “use the template”
5.
Figure 18-23.
Using the Save As dialog window