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.



STEP BY STEP - 10.2

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%'
    GO
    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

Dig deeper on SQL Server Database Modeling and Design

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close