Book Excerpt

Quick steps: Creating a trace

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 first published in January 2006

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: