| Track: | Enterprise Database Administration and Deployment |
|---|---|
| Level: | 100 (Novice) |
| Abstract: | 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. |
This presentation has been/will be delivered at the following event(s):
| Version | Date | Event |
|---|---|---|
| 1.1 | 2010-08-14 | SQLSaturday #28 |
| 1.2 | 2011-04-02 | SQLSaturday #63 |
| 1.3 | 2011-04-20 | April user group meeting |
| 1.4 | 2011-06-03 | CodeStock 2011 |
| 1.5 | 2011-10-01 | SQLSaturday #97 |
The following Zip files contain the downloadable presentation materials (slides, code, and handout(s)):
- Release 1.0005.0004.0000 (2011-10-01)
- Release 1.0004.0003.0000 (2011-06-03)
- Release 1.0003.0003.0014 (2011-04-24)
- Release 1.0001.0001.0009 (2010-10-27)
