Manage Learn to apply best practices and optimize your operations.

Quick steps: Creating a trace

Get steps for creating a trace in SQL Profiler in this book excerpt from MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation.

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.


Creating a trace

  1. Open the profiler by selecting SQL Enterprise Manager(found in Programs, SQL Server 2000) from the Start menu, and then selecting Tools, Profiler.

  2. 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.

  3. FIGURE 10.6: Creating a trace in the SQL Profiler.
  4. 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%'
    SELECT *
    FROM titles

  5. Now end the trace by going back to the Profiler and clicking the Stop button or selecting File, Stop Trace from the menu.

Click for the complete book excerpt series.

This was last published in January 2006

Dig Deeper on SQL Server Database Modeling and Design

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.