Tracing statements in SQL Server 2000

Create a new trace and choose the following events:

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:

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

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT SQL Server performance and tuning Tips for tuning SQL Server 2005 to improve reporting performance SQL Server errors, failures and other problems fixed from the trenches SQL Server database design disasters: How it all starts Can you shrink your SQL Server database to death? Parent-child dimensions in SQL Server 2005 with Analysis Services MDX SQL Server database design disasters: What not to do Tuning SQL Server performance via memory and CPU processing Troubleshoot Web service issues in SQL Server 2005 Reporting Services Ordering the results of a SQL query Configuring SQL Server with a changed computer name SQL Server data warehousing/business intelligence Tips for tuning SQL Server 2005 to improve reporting performance Parent-child dimensions in SQL Server 2005 with Analysis Services MDX Troubleshoot Web service issues in SQL Server 2005 Reporting Services Ordering the results of a SQL query SSIS error message due to installation problem on SQL Server 2005 Using MDX and UDM in a SQL Server Analysis Services environment Configuring SQL Server with a changed computer name Change data capture in SQL Server 2008 improves BI reporting accuracy Manage traces in SQL Server 2005 Analysis Services with XMLA commands Tutorial: SQL Server 2005 Analysis Services SQL Server stored procedures SQL Server trigger vs. stored procedure to receive data notification How to use SQL Server 2008 hierarchyid data type SQL and SQL Server Tutorial and Reference Guide SQL Server stored procedures tutorial: Write, tune and get examples Check SQL Server database and log file size with this stored procedure SQL Server source code analysis and management adds database security Configure SQL Server Service Broker for sending stored procedure data Find size of SQL Server tables and other objects with stored procedure Track changes to SQL Server 2000 and 2005 with one simple utility Troubleshoot SQL Server 2005 temporary table performance problems

RELATED GLOSSARY TERMS Terms from Whatis.com − the technology online dictionary contiguity  (SearchSQLServer.com) contiguous  (SearchSQLServer.com) drilldown  (SearchSQLServer.com) hashing  (SearchSQLServer.com) hybrid online analytical processing  (SearchSQLServer.com)

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary