New Microsoft SQL Server Video Tutorial: Pt. 3 - Performance Tuning Profiler and Traces By Adding Filters and Working with Large Traces

Pt. 3 - Performance Tuning Profiler and Traces By Adding Filters and Working with Large Traces - view details

The filters you choose (or don't choose) can definitely give you improved throughput for your traces. This video walks you through how to set up the filters and designing traces for performance. At the end of this video, a great demo of how organize your traces for easier readability and troubleshooting.

Highlights from this video:

• What filters should I use when I want to filter for long running/slow queries?
• What are Reads and Duration and why are they important?
• How can I only trace my application (not SQL Server Agent, for example)
• Tracing for performance tuning
• What Event Classes use what Filters
• Suggestions for using filters to create more manageable traces

and much more

---

• Source: SQL Server videos
• Category: Performance Tuning SQL Server
• Skill Level: 400 (Intermediate - Advanced)
• Length: 8:20 (0.00MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

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

---

Keywords Associated with this video: sql trace, sql profiler, sql server 2000 profiler, profiling, sql sniffer, sniffing sql, tracing sql, grouping, filtering, limit