The following excerpt, courtesy of Que Certification, is from
Chapter 10 of the book MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation by Thomas Moore and Ed Tittel. Click for the complete book excerpt series or purchase the book.
STEP BY STEP - 10.2
Creating a trace
- Open the profiler by selecting SQL Enterprise Manager(found in Programs, SQL Server 2000) from the Start menu, and then selecting Tools, Profiler.
- Click on File, New Trace, provide login information if necessary, and then type MyTrace in the Trace Name text box. Check Save to File; this saves the workload file onto disk for future use. Save the trace as C:MyTrace.trc, and then execute the trace by selecting Run in the Trace Properties dialog box, as shown in Figure 10.6.
- Now you have to manually make SQL Server process queries so that the trace you just set up may be able to monitor the events configured. To do this, switch to the SQL Query Analyzer and execute the following query:
SELECT * FROM Authors WHERE au_fname LIKE 'C%' GO SELECT * FROM titles
- Now end the trace by going back to the Profiler and clicking the Stop button or selecting File, Stop Trace from the menu.
FIGURE 10.6: Creating a trace in the SQL Profiler.
Click for the complete book excerpt series.
This was first published in January 2006