Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

SQL Server: Collecting and Analyzing Trace Data

via Pluralsight

Overview



One of the easiest ways to collect information about SQL Server workloads is to capture trace information. This course will introduce you to using SQL Trace and SQL Profiler for tracing SQL Server activity, including common pitfalls and problems to avoid. You'll learn how to analyze the collected information using a variety of methods that will help with performance troubleshooting, workload benchmarking, activity auditing, and much more. The course is perfect for developers and DBAs who need to collect information about workloads running on SQL Server for analytic purposes. The information in the course applies to all versions from SQL Server 2005 onwards.

Syllabus

  • Introduction 5mins
  • SQL Trace Architecture 9mins
  • Using SQL Server Profiler 43mins
  • Server-Side Trace 28mins
  • Tracing Scenarios 54mins
  • Analzying Trace Data 48mins
  • Replaying Trace Workloads 41mins

Taught by

Jonathan Kehayias

Reviews

4.5 rating at Pluralsight based on 132 ratings

Start your review of SQL Server: Collecting and Analyzing Trace Data

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.