Tracing statements in SQL Server 2000

Use SQL Profiler in your production environment to target poorly performing T-SQL commands in SQL Server 2000 and SQL 2005. Microsoft database expert Michelle Gutzait guides you through SQL Trace, from how to use trace definition through incorporating SSIS/DTS packages into the process. Locate problematic T-SQL commands and send the reports to your SQL Server development team.

In SQL Server 2000:

Create a new trace and choose the following events:

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

Choose the minimal amount of columns (don't forget to add the DatabaseID):

Note: The data columns shown above, make up the minimum list of necessary columns.

Choose the filters, for example:

CPU > 500

Duration > 500 (half a second)

Reads > 10,000

Writes > 5000

Run the trace and script it:

Targeting SQL Profiler to determine performance problems
Home: Introduction
Step 1: Tracing statements in SQL Server 2000
Step 2: Tracing statements in SQL Server 2005
Step 3: How to use SQL Trace definition
Step 4: Script example for SQL Trace
Step 5: SQL Trace results in SQL Profiler

ABOUT THE AUTHOR:

Michelle Gutzait works as a senior databases consultant for ITERGY International Inc., an IT consulting firm specializing in the design, implementation, security and support of Microsoft products in the enterprise. Gutzait has been involved in IT for 20 years as a developer, business analyst and database consultant. For the last 10 years, she has worked exclusively with SQL Server. Her skills include database design, performance tuning, security, high availability, disaster recovery, very large databases, replication, T-SQL coding, DTS packages, administrative and infrastructure tools development, reporting services and more.
Copyright 2007 TechTarget

More on SearchSQLServer.com

Step-by-Step Guide: How to interpret performance metrics in SQL Server 2005

Using SQL Server Profiler with Analysis Services

FAQ: DTS packages in SQL Server

This was last published in March 2007

Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning

All
News
Get Started
Evaluate
Manage
Problem Solve

SearchBusinessAnalytics

Dig Deeper on Microsoft SQL Server Performance Monitoring and Tuning

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.