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.
When sQl Profiler opens, access the file menu to create a new trace, as shown in
Figure 18-14 .
3.
When the Trace Properties dialog window appears, fill in the “Trace name” textbox
with ETLProcessingPerformance , as shown in Figure 18-17 .
4.
in the Trace Properties dialog window, select Tuning in the “use the template”
dropdown box, as shown in Figure 18-17 .
5.
Check the “save to file” checkbox. This launches the save As dialog window (Figure 18-23 ) .
Figure 18-23. Using the Save As dialog window
 
Search WWH ::




Custom Search