SQL Trace results in SQL Profiler

We can summarize the traced data in few modes, such as:

Conclusion:
You can record bad performing T-SQL in your servers and send the information to the developers on a regular basis allowing them to be pro-active to performance issues.

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 Microsoft SQL Server SQL Server errors, failures and other problems fixed from the trenches SQL Server consolidation: Why it's an optimization technique Can you shrink your SQL Server database to death? Using SQL Server datetime functions GETDATE, DATENAME and DATEPART Tuning SQL Server performance via memory and CPU processing Get SQL Server log shipping functionality without Enterprise Edition SQL Server 2008 backup compression pros and cons How to use SQL Server 2008 hierarchyid data type Tuning SQL Server performance via disk arrays and disk partitioning Should you upgrade to SQL Server 2005 or SQL Server 2008? 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

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