An Introduction to Profiler and SQL Trace
Duration: 60 minutes
Track: DBA 1
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.
No material found.