New Microsoft SQL Server Video Tutorial: Pt. 2 - Determining Which Events, Data Columns and Filters to Use in Your Trace

Pt. 2 - Determining Which Events, Data Columns and Filters to Use in Your Trace - view details

You can significantly impact your trace's "drag" on your SQL Server by wisely choosing your events, data columns, and filters when you start your trace. This video walks you through the Event Classes (and makes suggestions as to which to use for what purpose), what common Data Columns are used (and what are Data Columns anyway?), and how filters can be used (what Event Classes use what Filters?).

Highlights from this video:

• Suggestions for using filters to create more manageable traces
• Tracing for performance tuning
• Tracing errors
• Viewing trace data and interpreting Profiler's results
• What's the difference between "Profiler" and a "trace"?
• SQL Batches and the SP:BatchCompleted Event Class

and much more

• Category: Performance Tuning SQL Queries: Indexes and Execution Plans
• Skill Level: 300 (Intermediate)
• Length: 14:50 (0.00MB)
• Applies to Versions: SQL Server 2000
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required

Note: You must have the TSCC codec installed to view this video