Introduction to SQL Trace

A session at CodePaLOUsa 2012

Friday 16th March, 2012

3:30pm to 4:30pm (EST)

While many DBAs and developers are familiar with SQL Server Profiler, they are not familiar with SQL Trace. Very briefly, SQL Trace allows you to capture Profiler traces using system stored procedures, without the extra overhead of using the Profiler GUI, helping to minimize the amount of resources used for capturing traces. SQL Trace can be especially helpful to developers who want to see what their code is sending to SQL Server, helping when troubleshooting code or performance problems.

In this session you will learn: What is SQL Trace; The Pros and Cons of Using SQL Trace; How SQL Trace Works; What are the SQL Trace System Stored Procedures; How to Create Your Own SQL Trace Script; How to Query Trace Data Directly From a Trace File; and How to use the SQL Server Profiler GUI to Automatically Write SQL Trace Scripts.

This session is filled with demonstrations, and assumes attendees have a basic understanding of how to use Profiler. After attending the session, attendees will be able to return to work and immediately put what they have learned into practice.

About the speaker

This person is speaking at this event.
Brad M McGehee

SQL Server MVP; Director of DBA Education, Red Gate Software; SQL Server database administrator, writer and trainer. bio from Twitter

Sign in to add slides, notes or videos to this session

Tell your friends!


Time 3:30pm4:30pm EST

Date Fri 16th March 2012

Short URL


Official session page


View the schedule


See something wrong?

Report an issue with this session