Details

An Introduction to Profiler and SQL Trace

Speaker: Trevor Barkhouse

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.

Accompanying Material

No material found.


Back to Top
cage-aids
cage-aids
cage-aids
cage-aids