YoVDO

SQL Server: Replacing Profiler with Extended Events

Offered By: Pluralsight

Tags

Extended Events Courses Data Analysis Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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

Related Courses

Monitor and optimize operational resources in Azure SQL
Microsoft via Microsoft Learn
SQL Server Administration Part 2
Udemy
SQL Server Performance Tuning Part 2
Udemy
Extending Your Use of Extended Events
PASS Data Community Summit via YouTube
Azure SQL Database - Lessons Learned from the Trenches
PASS Data Community Summit via YouTube