Tracing statements in SQL Server 2005

Create a new trace and choose the following events and columns:

Add the column filters accordingly.

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 availability Licensing a standby server for SQL Server replication Get SQL Server log shipping functionality without Enterprise Edition Monitor database mirroring and replication after a SQL Server upgrade Upgrade live applications to SQL Server 2005 for high availability SQL Server high availability when upgrading to SQL Server 2005 Tutorial: Migrating to SANs from local SQL Server disk storage How to restore SQL Server database to transition server during upgrade SQL Server memory configurations for procedure cache and buffer cache Upgrade Active/Active cluster to SQL Server 2005 and Windows 2003 SQL Server backups using SAN database snapshots SQL Server availability Research

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