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

Pluralsight

SQL Server: Replacing Profiler with Extended Events

via Pluralsight

Overview

Use your knowledge of Profiler and Trace to help learn how to effectively use their replacement: Extended Events. If you use Trace or Profiler in SQL Server, in any capacity, this course is relevant to you.

There have been three new releases of SQL Server since the introduction of Extended Events (XE) in SQL Server 2008, and DBAs and Developers alike still prefer Profiler. It's time to move on. If you've tried Extended Events and struggled, or if you've been thinking about it but just aren't sure where to begin, then this course is for you. Using your existing knowledge and experience, this course will bridge the gap between Profiler and XE through a series of demos, including how to create an Extended Events session using an existing Trace, how to create one in the UI from scratch, how to analyze the data, and what to watch out for in terms of performance. If you use Trace or Profiler in SQL Server, in any capacity, regardless of what you do as part of your day-to-day job, this course is relevant to you.

Syllabus

  • Course Overview 1min
  • Introduction 16mins
  • Transitioning from Profiler’s UI to Extended Events 46mins
  • Leveraging the Extended Events UI 34mins
  • Understanding Target Options for Extended Events 25mins
  • Avoiding Performance Issues with Extended Events 23mins

Taught by

Erin Stellato

Reviews

4.8 rating at Pluralsight based on 88 ratings

Start your review of SQL Server: Replacing Profiler with Extended Events

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.