SQL Server - Advanced Extended Events

WMV | WMV3 177kbps | English | 1024x768 | 15fps | 4h 14mins | WMA2 stereo 128kbps | 466 MB

Genre: Video Training

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.

Table of contents:

Introduction5m 3s

Getting More From Event Sessions43m 24s

Event Session Options43m 55s

Advanced Targets55m 39s

Advanced UI Features24m 23s

Extended Events .NET API and PowerShell Integration38m 36s

Advanced Troubleshooting Scenarios43m 20s