New Microsoft SQL Server Video Tutorial: Pt. 1 - Using SQL Profiler - Concepts and Screens

Pt. 1 - Using SQL Profiler - Concepts and Screens - view details

SQL Server Profiler is one of the greatest SQL Server admin tools ever - you absolutely need to know it! This video walks you through the basics of "What is SQL Server Profiler?" and "How do I run Profiler?"

Highlights from this video:

• What traces are and how to use them
• Security requirements for running Profiler
• Using (local) or . or any alias in Profiler - good or bad?
• Concepts of server-side tracing vs. client-side traces
• Suggestions for naming traces
• Explanation of rollover files and Best Practices for using Profiler
• Should You Trace to File or Trace to Table? What's the "Best Practice"?
• Using templates

and much more

• Category: Performance Tuning SQL Queries: Indexes and Execution Plans
• Skill Level: 300 (Intermediate)
• Length: 9:00 (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