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

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

This video, part 2 in our "Intro to Profiler" series, provides a great overview of the various Events (also called "Event Classes") and how the Data Columns work. You'll also see how to choose the various options and how to group columns in Profiler for easier navigation over large traces. 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 gives you several creative ideas for doing yo ur own traces.

Highlights from this video:

• New Events in SQL Server 2005
• How templates affect your events and columns
• Tracing for performance tuning
• Tracing errors
• What's the difference between "Profiler" and a "trace"?

and much more

---

• Source: http://www.learnsqlserver.com
• Category: Performance Tuning SQL Server
• Skill Level: 300 (Intermediate)
• Length: 11:59 (0.00MB)
• Applies to Versions: SQL Server 2005
• 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

---

Keywords Associated with this video: sql trace, RPC:Complete, CursorOpen, Deadlock, Exception, Data File Auto Grow, SP:CacheMiss, SP:CacheInsert