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

Pluralsight

SQL Server: Advanced Extended Events

via Pluralsight

Overview

Learn how to use the advanced features of Extended Events for more in-depth troubleshooting on SQL Server, either through Transact-SQL or the Extended Events UIs, applicable for developers and DBAs who have some Extended Events and troubleshooting experience, for SQL Server 2008 onwards

This course builds on the SQL Server: Introduction to Extended Events course and delves deeper into the Extended Events system to show you more advanced features, options, targets, and scenarios. The course starts by showing how to develop more powerful event sessions and also set the various event session options to control memory management, event dispatching and retention, and how to track linked events. It then presents the advanced event targets, along with the potential problems you may encounter when using them, and the advanced features of the SQL Server 2012 Extended Events UI in Management Studio, and how to leverage Extended Events using both the .NET API and PowerShell. The course ends by presenting some complex troubleshooting scenarios and shows how they can be investigated using Extended Events.This course is perfect for those with some experience of Extended Events and troubleshooting, as all the knowledge in the SQL Server: Introduction to Extended Events course is assumed. The information in the course applies to all versions from SQL Server 2008 onwards.

Syllabus

  • Introduction 5mins
  • Getting More From Event Sessions 43mins
  • Event Session Options 43mins
  • Advanced Targets 55mins
  • Advanced UI Features 24mins
  • Extended Events .NET API and PowerShell Integration 38mins
  • Advanced Troubleshooting Scenarios 43mins

Taught by

Jonathan Kehayias

Reviews

4.7 rating at Pluralsight based on 60 ratings

Start your review of SQL Server: Advanced 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.