TOPIC: An Introduction to Profiler and SQL Trace
Profiler (and its underlying subsystem, SQL Trace) is a tool for recording a SQL Server instance's activity. This diagnostic and performance data is valuable for troubleshooting and characterizing a system's workload. Like any powerful tool, misuse can be quite harmful, so great care must be exercised. This session will teach you how to efficiently configure, run, and analyze the data from traces, while minimizing the overhead of the data collection and avoiding common pitfalls.
Trevor Barkhouse is an Escalation DBA for Terremark Worldwide, Inc., a leading global provider of IT infrastructure services. His passions are automation, performance tuning, and troubleshooting. Trevor has spoken at many user group meetings, seven SQLSaturday events, the 2010 Houston TechFest, and last two the PASS Community Summits (North American).